初学者求教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)
语法是这样改,不过还没看懂你要干什么