Home >Database >Mysql Tutorial >sql 2000/2005几种分页方法
sql 2000/2005几种分页方法
- WBOYOriginal
- 2016-06-07 17:48:22996browse
通过SQL 查询分析器，显示比较：我的结论是:分页方案二：(利用ID大于多少和SELECT TOP分页）效率最高，需要拼接SQL语句分页方案一：(利用Not In和SELECT TOP分页) 效率次之，需要拼接SQL语句分页方案三：(利用SQL的游标存储过程分页) 效率最差，但是最为通用
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：Select语句，join，union用法Next article：sql语句 大量占用内存的查询解决办法