Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> select and rownum and order by
I want select 'n' lines ordered in a select SQL
this select don't work:
select * from thetable where rownum < 10 order by thedate
because it's return first the 10 lines and sort.
I want first sort and the 10 lines, but i don't want sort all the table.
I don't want use a cursor because i have a big table.
Have you a solution ????
-- Laurent LETANG mailto:Laurent.Letang_at_ansf.alcatel.fr ALCATEL TITN ANSWARE 1, Rue du chateau de l'eraudiere 44300 NANTES FRANCEReceived on Thu Jan 15 1998 - 00:00:00 CST
![]() |
![]() |