摘要： ----方法1：WITH UserInfos AS(select *,row_number() over(order by user_id) as RowNumberfrom user_info)select *from UserInfoswhere RowNumber between 21 and 30----方法2：select * from(select *,row_number() over(order by user_id desc) as RowNumberfrom user_info) Awhere RowNumber between 21 and 30 阅读全文