摘要：以下都以查询第二页11-20条记录为例 1.两层子查询嵌套（不排序的话只用嵌套1层） Select * from ( Select rownum rn,t.* from (Select * from user order by salary desc) t where rn <= 20 ) wher 阅读全文