insert into table1(a,b) (select top 1 a,b from table2 where id=33 order by datetme desc)如上我要取出最新的一条数据,但是报错 order 附近语法错误!各位帮忙看看!
insert into table1(a,b) (select top 1 a,b from table2 where id=33 order by datetme desc)如上我要取出最新的一条数据,但是报错 order 附近语法错误!各位帮忙看看!
insert into table1(a,b) select top 1 a,b from table2 where id=33 order by datetme desc
那我不加order的时候,有括号好像还没报错
insert into table1(a,b) (select top 1 a,b from table2 where id=33 order by datetme desc)
多了括号!
(select top 1 a,b from table2 where id=33 order by datetme desc)
AS T