Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use LIMIT in SQL

517920Sep 12 2006 — edited Sep 13 2006
How to use LIMIT predicate in SQL?
Is it work in SQL 9.2?


It is giving following (same) error when i try to execute query in both situations...

SQL> SELECT * FROM EMP LIMIT 0,10;
SELECT * FROM EMP LIMIT 0,10
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

SQL>SELECT * FROM EMP LIMIT 2
*
ERROR at line 1:
ORA-00933: SQL command not properly ended

Please reply,

Thanks,
Suman0Naidu.S
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2006
Added on Sep 12 2006
4 comments
5,600 views