5.限制结果集范围

限制结果集行数

select top 5 * from emp order by salary desc

(*)检索按照工资从高到低排序检索从第六名开始一共三个人的信息：

select top 3 * from emp where number not in

(select top 5 number from emp order by salary desc)

order by salary desc

sqlserver2005后增加了row_number函数简化实现