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
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