How to use LIMIT in SQL
517920Sep 12 2006 — edited Sep 13 2006How 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