SQL 高效分页查询
标签：
SQL 高效分页查询
@page int --页码
declare @pagecount int;--每一页显示的记录数
set @page=2
set @pagecount=6
select * from (select *,row_number() over( order by id asc) as row from ADTypes) as a
where row between (@page*@pagecount-@pagecount+1) and (@page*@pagecount)