I was running the following query in Oracle Live SQL Server :
SELECT * FROM t1 LIMIT 2;
where t1 is my table_name and I studied about LIMIT clause from w3schools , the syntax is hopefully correct but it is still showing this error .
*SQL command not properly ended*
Please help I am just a beginner.
The error is written in my question sir. It is showing
ORA-00933: SQL command not properly ended
Hi, Oracle does not know "limit n" but you can use "where rownum <= 2" instead.