+ 1

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

16th Feb 2018, 10:17 PM
Munaf Ahmed
Munaf Ahmed - avatar
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;
17th Feb 2018, 9:07 AM
Ravi Chandra Enaganti
Ravi Chandra Enaganti - avatar
0
what is the command? exactly paste it here
17th Feb 2018, 6:14 AM
Ravi Chandra Enaganti
Ravi Chandra Enaganti - avatar
0
its "Select * from table_name Limit 5;
17th Feb 2018, 6:56 AM
Munaf Ahmed
Munaf Ahmed - avatar
0
Thanks alot
17th Feb 2018, 11:52 AM
Munaf Ahmed
Munaf Ahmed - avatar