2018年5月25日
sql server 分页语句
摘要： SELECT * FROM ( SELECT *,ROW_NUMBER() OVER(ORDER BY DjLsh) AS rowId FROM dbo.UsersH ) AS b WHERE b.rowId BETWEEN 10 AND 20 AND (IsDelete='0' or IsDelete is NULL) 阅读全文
posted @ 2018-05-25 09:49 紫晶城 阅读(100) 评论(0) 推荐(0) 编辑