SQL command not properly ended

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.

2 comments

Community moderators have prevented the ability to post new comments.

Hi @Kulmeet Singh and welcome to the community,

Is the an error code with that error?

The error is written in my question sir. It is showing

ORA-00933: SQL command not properly ended

@Kulmeet Singh no, you hadn't mention ORA-00933 :/

Hi, Oracle does not know "limit n" but you can use "where rownum <= 2" instead.