SQL Server 2005 提供的分页查询支持
- WBOYOriginal
- 2016-06-13 10:06:351088browse
今天刚刚看到，没有测试性能。
SELECT *
FROM (select ROW_NUMBER() Over(order by CreditCardID) as rowNum, *
from Sales.CreditCard) as table
where rowNum> 0 and rowNum
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：通过缓存数据库结果提高PHP性能(3)Next article：通过缓存数据库结果提高PHP性能(2)