Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> limit clause of a select command

limit clause of a select command

From: Julien GILLE <julien_at_alban.elzeo.com>
Date: Fri, 26 Nov 1999 20:56:51 +0100
Message-ID: <383EE603.3BB3FA74@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 - 13:56:51 CST

Original text of this message

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