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)  编辑  收藏  举报