sqlServer-简单分页查询例子

字数统计: 132 | 阅读时长≈ 1 分钟

工资从高到低排序输出工资是第4到6行数据

select top 3 * 
from emp 
where EMPNO not in(select top 3 EMPNO from emp order by sal desc) 
order by sal desc

工资从高到低排序输出工资是第13到15行数据

select top 3 * 
from emp 
where EMPNO not in(select top 12 EMPNO from emp order by sal desc) 
order by sal desc

总结：假设每页显示n条记录，当前要显示的第m页表名是A 主键是A_id

1
2
3

select top n* 
from A 
where A\_id not in(select top(m-1)*n A\_id from emp)