Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL PUZZLE: selecting top 50 salaries in a table
How about using "WHERE ROWNUM <= 50" with an order by clause?
NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
news:380f8e89.268436409_at_news.earthlink.net...
> Well.. we know how to select top salary, which is select max(salary),
> but how would I select top 50 records?
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Fri Oct 22 1999 - 08:47:45 CDT