Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> select and rownum and order by

select and rownum and order by

From: Laurent LETANG <laurent.letang_at_ansf.alcatel.fr>
Date: 1998/01/15
Message-ID: <34BDDBA2.4BBE@ansf.alcatel.fr>#1/1

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 FRANCE
Received on Thu Jan 15 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US