Re: How to get the first 10 records(with order by)?

From: acorn <mcbcon_at_my-deja.com>
Date: Mon, 04 Oct 1999 16:40:27 GMT
Message-ID: <7tal9p$8bl$1@nnrp1.deja.com>

In article <7t9gfi$ecq$1_at_nnrp1.deja.com>, wy_at_fudan.edu wrote:
> How to get the first 10 records in a sql(with order by)?
> In sqlserver7.0,
> I can use "select first 10 * from orders order by saledate" to get the
> first 10 records,and how to do this in oracle?
>
> any suggestions are helpful!
> thanks in advance!
>

acorn:
Try select * where rownum <11 order by sumfield;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 04 1999 - 11:40:27 CDT