This is how it is used in different databases:
1. Select top sql usage supported in access/ms sql server;
2. The supported sql usage in mysql/oracle is select...limit;
There is no difference between the two in terms of usage. It’s just that the application platform is different.
mysql> SELECT TOP 2 * FROM ac_article_img;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
near '2 * FROM ac_article_img' at line 1
Which version of Mysql are you using? It seems that this query is not supported after 5.0.
This is how it is used in different databases:
1. Select top sql usage supported in access/ms sql server;
2. The supported sql usage in mysql/oracle is select...limit;
There is no difference between the two in terms of usage. It’s just that the application platform is different.
Which version of Mysql are you using? It seems that this query is not supported after 5.0.