Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL command not properly ended

Kulmeet Singh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 7, 2022

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 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
P. van der Heyden
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 4, 2022

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

0 votes
Alex Koxaras -Relational-
Community Champion
October 8, 2022

Hi @Kulmeet Singh and welcome to the community,

Is the an error code with that error?

Kulmeet Singh
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 8, 2022

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

ORA-00933: SQL command not properly ended

Alex Koxaras -Relational-
Community Champion
October 8, 2022

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

TAGS
AUG Leaders

Atlassian Community Events