Top 20 records in a table ??

From: agichen <agiNOagSPAM_at_feib.com.tw.invalid>
Date: Mon, 10 Jan 2000 01:55:41 -0800
Message-ID: <1ca4f2e8.4b527e23_at_usw-ex0102-016.remarq.com>

Hello,

[Quoted] [Quoted]    How to select the highest 20 records from a table via sql*plus ??    For example,
   emp table

---

[Quoted]    id number(5),
   name varchar2(20),
[Quoted]    pay number(8)

[Quoted] [Quoted]  how to select the highest 20 pay from emp ??

  Any idea ??
Rgds,
Agi

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Mon Jan 10 2000 - 10:55:41 CET