Re: TOP N in Oracle

Jining Han wrote:

> where rownum<=10
> order by ... desc

You mean that, I hope:

select

   cols
from

   (select * from tab order by ordering_cols) ordered_query where

   rownum <= 10
;

Kind regards,

-- 
"For every developer that thinks he can create something that is
non-database specific ... there are two people being paid by the
hour to clean up the mess later" (Daniel A. Morgan)