Re: TOP TEN LISTS? HELP.
From: Sunil Mushran <smushran_at_us.oracle.com>
Date: 16 Dec 1994 01:43:59 GMT
Message-ID: <3cqrcv$d0k_at_dcsun4.us.oracle.com>
Date: 16 Dec 1994 01:43:59 GMT
Message-ID: <3cqrcv$d0k_at_dcsun4.us.oracle.com>
Actually it is basic...that is, if I got you correct!
select * from table where rownum<11;
will get you the first 10 rows....
mwmaher_at_ACM.ORG wrote:
>
> How do you create a listing of the top N items in a table
> with straight SQL? This seems like such a basic task -
> until you try it.
>
> Thank you in advance.
Received on Fri Dec 16 1994 - 02:43:59 CET