子查询:(IN和NOT IN)
select a,b,c from a where a IN (select d from b )
或者: select a,b,c from a where a IN (1,2,3)
select a,b,c from a where a NOT IN (select d from b )
或者: select a,b,c from a where a NOT IN (1,2,3) [相反]
(EXISTS 和 NOT EXISTS)
IF EXISTS (子查询)
语句
如果子查询的结果非空,则EXISTS(子查询)将返回真(true),否者返回假(false)。
NOT EXISTS 实现取反操作,表示不存在。
选择从10到15的记录 :
select top 5 * from (select top 15 * from table order by id asc) table_别名 order by id desc