nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL command not properly ended

Kulmeet Singh

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.

Comments

Alex Koxaras -Relational-

Hi @Kulmeet Singh and welcome to the community,

Is the an error code with that error?

Kulmeet Singh

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

ORA-00933: SQL command not properly ended

Alex Koxaras -Relational-

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

Alex Koxaras -Relational-

See this thread here https://stackoverflow.com/questions/8940471/sql-error-ora-00933-sql-command-not-properly-ended

P. van der Heyden

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

off-topic