sql分页

很少用到sql去分页，但是必要的时候，还是要会的

SELECT * FROM Sys_User AS A
LEFT JOIN
(
SELECT ROW_NUMBER() OVER( ORDER BY OrgID) AS indexs ,ID FROM dbo.Sys_User --效率 次之
) AS B ON A.ID = B.ID
WHERE B.indexs > 0 AND B.indexs <= 10

indexs列已出现，具体可调整