初学者求教SQLSERVER查询的一个小问题select top 4 * from (select id from article where title like %s
初学者求教SQLSERVER查询的一个小问题
select top 4 * from (select id from article where title like '%sdf%' or cont like '%sdf%') where id not in (select top 0 id from (select id from article where title like '%sdf%' or cont like '%sdf%'))
sqlserver 数据库 提示where附近有错
[解决办法]
select top 4 * from (select id from article where title like '%sdf%' or cont like '%sdf%') as a where id not in (select top 0 id from (select id from article where title like '%sdf%' or cont like '%sdf%') as b)
语法是这样改，不过还没看懂你要干什么