sql server 分页

declare
@pageNo int,
@pageSize int
set @pageNo=%s —–页码
set @pageSize=%s—–条数
begin
WITH query AS ( %s ) —-查询语句
SELECT * FROM query q
WHERE q.rn BETWEEN (@pageNo-1)@pageSize+1 AND @pageNo@pageSize
ORDER BY q.rn
end