Home >Database >Mysql Tutorial >SQL2005 大数据量检索的分页
SQL2005 大数据量检索的分页
- WBOYOriginal
- 2016-06-07 18:04:29910browse
仅列出实例SQL，其他的请大家自己完成吧
@StartIndex为当前页起始序号，@EndIndex为当前页结束记录序号，可以直接作为参数输入，也可以通过输入PageSize和PageIndex计算得出代码如下:
select * from
(
select *,row_number() over(order by OrderColumn) as orderindex from TableName
) as a
where a.orderindex between @StartIndex and @EndIndex
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：Oracle9i取得建表和索引的DDL语句Next article：Oracle Portal及其门户网站开发概述