34,590
社区成员
发帖
与我相关
我的任务
分享
select
*
from
(
select
row_number() over (order by Id asc) as rownumber, *
from mytablename
where
DeviceId = 27 and
CreatedDateTime between '2013-06-27 10:00:00.000' and '2013-06-27 17:00:00.000'
) t
where
t.rownumber >= 31 and t.rownumber <= 40;
t.rownumber >= 31 and
t.rownumber <= 40;
0S
t.rownumber >= 31;
6S
测试3楼的语句 0S
建议用执行计划查查原因,是否缺少索引