你的位置:首页 > 数据库

[数据库]SQL 高效分页查询

declare @page int --页码declare @pagecount int;--每一页显示的记录数set @page=2set @pagecount=6select * from (select *,row_number() over( order by id asc) as row from ADTypes) as a where row between (@page*@pagecount-@pagecount+1) and (@[email protected])