我的这个SQL语句有什么问题吗？

来源：百度知道 编辑：UC知道 时间：2024/05/16 17:46:47
select top 1 from TB_SUbmit_info where Submit_info_no in (select tableone_no from tb_tableone where mouse_no = '080311901')order by version desc
select top 1 * from TB_SUbmit_info where Submit_info_no in (select tableone_no from tb_tableone where mouse_no = '080311901')order by version desc
还是不行啊
这是Mysql报的错
错误代码: 1064
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 TB_SUbmit_info where Submit_info_no in (select tableone_no from tb_tabl' at line 1

mysql 没有 top 1 是用 limit 呵呵
select * from TB_SUbmit_info where Submit_info_no in (select tableone_no from tb_tableone where mouse_no = '080311901') order by version desc limit 1

select top 1 from ...

你必须指明查找字段
如果全部查出来,可以用*

select top 1 * from ...

select top 1 * from TB_SUbmit_info where Submit_info_no in (select tableone_no from tb_tableone where mouse_no = '080311901')order by version desc