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.
Community moderators have prevented the ability to post new answers.
Hi, Oracle does not know "limit n" but you can use "where rownum <= 2" instead.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The error is written in my question sir. It is showing
ORA-00933: SQL command not properly ended
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.