Question

按雇员工资排序，查询第3条到第8条记录

select top 4 * from (select top 8 * from Employee order by job_lvl) Employee order by job_lvl 这个语句错了··错在什么地方··请知道的帮改正下·在就有谁介绍 查询第N条到第M条记录 有什么数学关系式嘛~？

Answer 1

select top 6 * from (select top 8 * from Employee order by job_lvl) table_别名 order by job_lvl

Answer 2

Select Top 4 * From EmPloyee Where Job_Lvl in (select top 8 job_lvl from Employee order by job_lvl) order by job_lvl