top.sql

来自「本代码简单明了」· SQL 代码 · 共 21 行

--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)