Re: limit clause of a select command

Oracle has the pseudocolumn rownum
select * from a limit 10
would read
select * from a
where rownum <= 10;

Warning: the rownums are determined before any order by.

Hth,

--
Sybrand Bakker, Oracle DBA
Julien GILLE <julien_at_alban.elzeo.com> wrote in message news: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 Fri Nov 26 1999 - 14:14:28 CST