SQL语句分页查询
<!--外套模板-->
select top 15* from (select ROW_NUMBER() over (order by 主键) AS RowNumber, * from(
-- 子查询start--
-- 子查询end--
)a)b where b.RowNumber>15*(n-1)
<!--外套模板-->
其中,n是页码
实际例子
-------------- 分页查询 start ---------------------------------
select top 15* from (select ROW_NUMBER() over (order by id) as RowNumber,* from (
-- 子查询 start
SELECT * FROM person WHERE pname LIKE '%%'
-- 子查询 end
) a ) b where b.RowNumber > 15*(1-1)
------- 分页查询 end ---------------------------------