限制结果集的行数,通过两个例子进行说明,还用上一篇的那个表
举例1:查找工资为前3的人员信息
select top 3 * from dbo.T_Employee order by Salary desc
举例2:按照工资从高到低排序,取从第六名开始一共三个人的信息
select top 3 * from T_Employee
where Number not in (select top 5 Number from T_Employee order by Salary desc)
order by Salary desc
举例3:SQL2005之后,有了个Row_Number函数,后面说。