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

...
where rownum <= 10

Roland Schaar
Gosch Consulting GmbH

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!
>
> wangyang.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 04 1999 - 05:59:35 CDT