Home >Database >Mysql Tutorial >分页查询（用row_number()和开窗函数over()更方便）
分页查询（用row_number()和开窗函数over()更方便）
- WBOYOriginal
- 2016-06-07 14:53:381861browse
分页查询（用row_number()和开窗函数over()更方便） 查询MyStudents表中第8页中的数据（每页3条记录） www.2cto.com --(1) select * from ( select *, ROW_NUMBER()over(order by FId asc) as Rnumber from MyStudents ) as Tbl3 where Rnumber between (3*7
分页查询（用row_number()和开窗函数over()更方便）
查询MyStudents表中第8页中的数据（每页3条记录）
www.2cto.com
--(1)
select * from
(
select *,
ROW_NUMBER()over(order by FId asc) as Rnumber
from MyStudents
)
as Tbl3
where Rnumber between (3*7+1) and 3*8
--(2)
select top 3 * from MyStudents
where FId not in
(select top (3*7) FId from MyStudents
order by FId )
order by FId
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：将sqlite查询结果导入到文本文件Next article：数据库合并重复记录