sqlserver多表联查分页

select * from(
select H_order.Id ,H_order.userID, ROW_NUMBER() over (order by H_order.Id Desc) as rowNumber from H_order inner join  H_User on H_order.userID=H_User.Id
) as t where    t.rowNumber between 1 and 10

原文：https://www.cnblogs.com/weiyiyong/p/10922428.html