SQL从入门到基础 - 06 限制结果集范围

一、限制结果集行数

  1. Select top 5* from T_Employee order by FSalary DESC

  2. （*）检索按照工资从高到低排序检索从第六名开始一共四个人的信息：

select top 4 * from T_Employee where FNumber not in (select top 5 FNumber from T_Employee order by FSalary DESC) order by FSalary DESC

  3. SQLServer2005后增加了Row_Number函数简化实现。

SQL从入门到基础 - 06 限制结果集范围

原文：http://www.cnblogs.com/zqBlog/p/4918729.html