ADO.NET学习笔记--限制结果集行数

SELECT top 5 * FROM T_Employee order by FSalary Desc

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

SELECT top 3 * FROM T_Employee

WHERE FNumber NOT IN (SELECT TOP 5 FNumber FROM T_Employee ORDER BY FSalary DESC)

ORDER BY FSalary DESC

SQLServer2005后增加了Row_Number函数简化实现，后面会讲。