我正在尝试将MS Access查询转换为MySQL,问题是将MS Access top转换为MySQL limit以获得相同的结果。当我将查询更改为limit时,会发现此版本的MySQL在子查询中不支持limit。a.FK_CONTRIBUTOR_ID) WHERE ((a.CLIP_ID) In
(select top
select top 1 * from database_name where nstatus='pending';
我使用的是MySQLV14.14Distrib5.7.30,for Linux (x86ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL