当前位置: 代码迷 >> Sql Server >> 菜鸟求教SQLSERVER查询的一个小疑点
  详细解决方案

菜鸟求教SQLSERVER查询的一个小疑点

热度:42   发布时间:2016-04-27 14:13:51.0
初学者求教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)

语法是这样改,不过还没看懂你要干什么
  相关解决方案