Re: SQL PUZZLE: selecting top 50 salaries in a table
From: David Blethen <dblethen_at_bhe.com>
Date: Fri, 22 Oct 1999 09:47:45 -0400
Message-ID: <38106a1a_at_news.cybertours.com>
Date: Fri, 22 Oct 1999 09:47:45 -0400
Message-ID: <38106a1a_at_news.cybertours.com>
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 - 15:47:45 CEST