SQL server 数据库部分语法
use test ;
select * from student ;
select top 3 * from student ; 取123行
select top 3 * from student where id not in( select top 3 id from student );取456行
select * from (select top 3 id from student ) mm ;
select top 4 * from student where id not in(select top 3 id from student where id not in( select top 3 id from student )); 取1237 四行