Another point to remember is that Rownum is applied before any 'order by'
clause So an 'order by' clause would sort the 10 rows output but not force
for example the 10 with the highest value in a given column to be output.
Rudy Zung wrote in message <7dttol$4eb$1_at_mailhost.prograph-inc.com>...
>
>joe.morris_at_wcom.com wrote
>>Excuse the very elementary question . . .
>>
>>I have a result set > 10000 rows, however, I only want to see 10
>rows, not all
>
>select * from foo where rownum < 10
>
>Rownum is a pseudo column that Oracle generates.
>
Received on Wed Mar 31 1999 - 15:14:53 CST
