sql分页

select * from ( select ROW_NUMBER() over(order by id Desc) as rowid,* from News) tb where tb.rowid between 1 and 5 )
posted @ 2015-01-10 23:37  andyxl  阅读(75)  评论(0)  编辑  收藏  举报