+ 1
In oracle i am running the limit command but it says "SQL command not properly ended" .There's no syntax error.?
4 Réponses
+ 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;
0
what is the command? exactly paste it here
0
its "Select * from table_name Limit 5;
0
Thanks alot