Re: Help Need for a Query

Vijai Kumar wrote:
> Hi,
>
> rownum is a pseudo column.
>
> When you say select * from emp where rownum < 10; it will select only
> the first 9 rows from the total query output.
> Each and every row returned will have the same rownum =1;
>
> When you say select * from emp where rownum >1; it will not return any
> rows beacuse every row has got rownum value = 1.
>
> Try rownum=1 in the above query u will notice that all rows will be
> returned.

I think you mean "every *first* row". So if first row is filtered out (like in the example), then every row will potentially be the first, and therefore have rownum = 1, but not the second row.

/Bent Received on Mon Jun 28 2004 - 17:09:23 CEST