LIMIT number of selected rows

Hi,

what is the Oracle SQL syntax to limit the number of rows returned by a select.

MS-SQL supports TOP to do this:

select TOP 1 * from stuff;

But what is the correct syntax for Oracle to get only the first entry?

Greetings, Georg Received on Wed Jan 21 2004 - 11:13:26 CST