日期:2014-05-18  浏览次数:20389 次

初学者求教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)

语法是这样改,不过还没看懂你要干什么