分享ｊａｖａ带来的快乐

我喜欢ｊａｖａ新东西

SQL Server 分页取数据语句

SELECT T1.* FROM (SELECT ROW_NUMBER() OVER ( ORDER BY userid desc) AS ROW_NUMBER, thinkphp.* FROM (SELECT  * FROM coupon_alipay_whitelist) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 40 + 1 AND 40 + 20)

posted on 2011-12-15 16:58 强强 阅读(308) 评论(0)  编辑  收藏 所属分类: SQLServer


只有注册用户登录后才能发表评论。
网站导航: