Re: limit clause of a select command

Hi,
it is not valid in Oracle 7,

Use:

Select *
From a
Where RowNum <= 10;

This command will return the first 10 rows

Greetings

Julien GILLE heeft geschreven in bericht <383EE603.3BB3FA74_at_alban.elzeo.com>...
>I would like to know if this command is valid on Oracle 7 :
>
>select * from a limit 10;
>
>My goal is to have only the first 10 lines of the result view.
>
>This command works fine wirh MySQL and PostgreSQL.
>
>Thanks.
>
>
>
Received on Sat Nov 27 1999 - 10:11:47 CST