In oracle i am running the limit command but it says "SQL command not properly ended" .There's no syntax error.?

Answer 1

Oracle does not support the limit clause. It is only supported by MySQL. To get first 20 rows, you can use the following.

select * from table fetch first 20 rows only;

Answer 2

what is the command? exactly paste it here

Answer 3

its "Select * from table_name Limit 5;

Answer 4

Thanks alot