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