SQL Server中的分页查询

分页查询很简单，具体代码如下：

--分页查询--查询1-3行数据
select top 3 * from emp order by sal desc;--查询4-6行数据
select top 3 *from empwhere empno not in (select top 3  empno from emp order by sal desc)order by sal desc;--查询7-9行数据
select top 3 *from empwhere empno not in (select top 6  empno from emp order by sal desc)order by sal desc;
--查询10-12行数据
select top 3 *from empwhere empno not in (select top 9  empno from emp order by sal desc)order by sal desc;--查询13-14行数据
select top 3 *from empwhere empno not in (select top 12  empno from emp order by sal desc)order by sal desc;