top.sql

本代码简单明了

--TOP

select * from jobs order by min_lvl

--返回具体行数
select top 3 * from jobs order by min_lvl

--返回比例行数
select top 50 percent * from jobs order by min_lvl

--在最后一行附加多行信息
select top 3 with ties * from jobs order by min_lvl

--数据分页





select top 4 * from jobs where job_id not in (select top 4 job_id from jobs)