本文介绍了一种使用SQL进行高效分页查询的方法。通过设置每页显示记录数及当前页码，利用ROW_NUMBER()函数结合ORDER BY子句来实现快速定位并获取指定范围内的数据。这种方法适用于大型数据库表中进行分页展示，能有效提升用户体验。
declare @per_page_count int,@page_index int ;
set @per_page_count = 50;
set @page_index = 1;
select * from (
select ROW_NUMBER() over(order by name) as row_num, Name from Account) as baseData
where row_num between @per_page_count * (@page_index -1) and @per_page_count * @page_index
set @per_page_count = 50;
set @page_index = 1;
select * from (
select ROW_NUMBER() over(order by name) as row_num, Name from Account) as baseData
where row_num between @per_page_count * (@page_index -1) and @per_page_count * @page_index
扫一扫
32万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
