sql 2005 row_number()分页 (备忘)
SELECT * FROM (SELECT row_number() OVER (ORDER BY rd_roadid desc) AS rowno,* FROM MS_Road) AS t WHERE rowno BETWEEN 201 AND 210
 posted on 2012-08-01 23:39  vingi_苍月  阅读(106)  评论(0)  编辑  收藏  举报