sql server 2005 分页功能[资料]

SELECT *
FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from table_info ) as myTable
where rowNum between 50 and 60;
[]

转载地址:
http://www.ljnid.cn/article.asp
lunzi   2007-11-23 16:35:00 评论:0   阅读:84   引用:0

发表评论>>

署名发表(评论可管理,不必输入下面的姓名)

姓名:

主题:

内容: 最少15个,最长1000个字符

验证码: (如不清楚,请刷新)

Copyright@2008 powered by YuLog