Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Finding out last 10 records
Spot on!
Using DISTINCT and indexes will also cause implicit sorting.
-----Original Message-----
Sent: Wednesday, August 14, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
(snipped a lot from Dan's reply......)
>
> As you can see, the rownum is not altered with the sort
> order. In order to
> retrieve the first 10 records by name, you need to have the
> output sorted
> prior to assignment of rownum.
... to point out that 'group by' will allow you to achieve sorted order and application of rownum.
peter
edinburgh
scan all attachments. http://www.bgs.ac.uk *********************************************************************
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: pgro_at_bgs.ac.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: Dan.Fink_at_mdx.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 14 2002 - 14:05:59 CDT
![]() |
![]() |