select * from
(
select * , ROW_NUMBER() OVER(ORDER BY id) px from tb
) t
where px between m and m+nselect top n * from
(
select * , ROW_NUMBER() OVER(ORDER BY id) px from tb
) t
where px>m
(
select * , ROW_NUMBER() OVER(ORDER BY id) px from tb
) t
where px between m and m+nselect top n * from
(
select * , ROW_NUMBER() OVER(ORDER BY id) px from tb
) t
where px>m
解决方案 »
- SQL 不同服务器,复制表的问题。
- 存储过程传参数的问题
- sql server经常被黑,有什么办法可以看到历史sql语句执行情况?
- 请问,怎么计算出来的结果竟然是0呀,应该是1.79多,在线等待
- 整个sql数据库导出的问题
- sql2000 插入数据失败
- 如何在存储过程中根据INPUT变量,动态的生成SELECT语句(解决就给分)
- ### icevi(按钮工厂)进来拿分,问题是:给ACCESS2000设定了“用户与组账户”,现在用不了 ###
- 怎样在已有的数据库里自动创建新表(在线等待)
- 大声喊叫:有没有在江苏软件园的朋友啊???????????
- 关于同一账号同时连接sql server
- 怎样使用关联达到以下查询效果
set showplan_text on
表碎片不一样 都会有影响的! SQL是基于成本的选执行计划
和 SET STATISTICS TIME
(
select * , ROW_NUMBER() OVER(ORDER BY id) px from tb
) t
where px between m and m+n更快
GOSET STATISTICS TIME ON
select * from
(
select * , ROW_NUMBER() OVER(ORDER BY SalesOrderDetailID) px
from Sales.SalesOrderDetail
) t
where px between 2 and 2+5select TOP 6 * from
(
select * , ROW_NUMBER() OVER(ORDER BY SalesOrderDetailID) px
from Sales.SalesOrderDetail
) t
where px > 2SET STATISTICS TIME OFF(6 行受影响)SQL Server 执行时间:
CPU 时间 = 344 毫秒,占用时间 = 50 毫秒。(6 行受影响)SQL Server 执行时间:
CPU 时间 = 391 毫秒,占用时间 = 53 毫秒。
GOSET STATISTICS TIME ON
select * from
(
select * , ROW_NUMBER() OVER(ORDER BY SalesOrderDetailID) px
from Sales.SalesOrderDetail
) t
where px between 10 and 110select TOP 101 * from
(
select * , ROW_NUMBER() OVER(ORDER BY SalesOrderDetailID) px
from Sales.SalesOrderDetail
) t
where px > 10SET STATISTICS TIME OFF
USE AdventureWorks;
GOSET STATISTICS TIME ON
select * from
(
select * , ROW_NUMBER() OVER(ORDER BY SalesOrderDetailID) px
from Sales.SalesOrderDetail
) t
where px between 10 and 110select TOP 101 * from
(
select * , ROW_NUMBER() OVER(ORDER BY SalesOrderDetailID) px
from Sales.SalesOrderDetail
) t
where px > 10SET STATISTICS TIME OFF
(101 行受影响)SQL Server 执行时间:
CPU 时间 = 283 毫秒,占用时间 = 49 毫秒。(101 行受影响)SQL Server 执行时间:
CPU 时间 = 373 毫秒,占用时间 = 322 毫秒。