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

From: <wy_at_fudan.edu>
Date: Mon, 04 Oct 1999 06:12:05 GMT
Message-ID: <7t9gfi$ecq$1@nnrp1.deja.com>

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 - 01:12:05 CDT

This message: [ Message body ]
Next message: Tom Zamani: "Re: How to drop a column?"
Previous message: Kovacs Richard: "Oracle 8"
Next in thread: Gerald Anleitner: "Re: How to get the first 10 records(with order by)?"
Reply: Gerald Anleitner: "Re: How to get the first 10 records(with order by)?"
Reply: Roland Schaar: "Re: How to get the first 10 records(with order by)?"
Reply: Mark G: "Re: How to get the first 10 records(with order by)?"
Reply: acorn: "Re: How to get the first 10 records(with order by)?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US