SQL关于带条件查询分页语句

带条件查询语句：Select * From table_name Where condition

然后利用with as TT（查询语句）将结果集设置为表TT

最后通过

declare @page_size int;
declare @page_num int;

--比如：每页10条记录
set @page_size = 10;

--比如：先取第1页
set @page_num = 1;

select *
from
(
select *,

(row_number() over(order by @@servername) - 1) / @page_size as pagenum
from from biao
)t
where pagenum = @page_num - 1 语句实现分页查询。