Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: advanced SQL
> SELECT MOD(ROWNUM+2,3) + 1, *
> FROM TEST;
? No.... this doesn't count the row in the correct way.
It only tells me
1,2,3,1,2,3,1,2,3,etc
that's not what I wanted.
row_number() over ... solver perfectly the problem. And it's faster than my trick. Received on Wed Jan 15 2003 - 04:04:47 CST