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函数简化实现,后面会讲。