Sql server 2005带来的分页便利

2009-12-26 00:58| 发布者: admin| 查看: 99| 评论: 0|原作者: 仙之剑缘

select threadid from
(
select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads
) as T
where T.Pos > 100000 and T.Pos < 100030
===========================================
如果里面的这个表cs_threads数据量超大，比如，几亿条记录，那这个方法应该是有问题的
因为，select threadid from
(
select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads
) as T
where T.Pos > 100000 and T.Pos < 100030
这个语句是把select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads它全部取出来，然后在SQL的外面进行分页的，没在SQL2005上测试过，因为原先在ORACLE上这样的写法是不好的，ORACLE中这样写比较好：select threadid from
(
select threadid, ROW_NUMBER() OVER (order by stickydate) as Pos from cs_threads a where a.pos<100030
) as T
where T.Pos > 100000
出处：blog.joycode.com/dotey/archive/2006/01/16/70493.aspx

收藏分享邀请

		自动登录	找回密码
密码			注册

Sql server 2005带来的分页便利

最新评论

相关分类