摘要： 方法1：利用ROW_NUMBER函数 SELECT NO FROM ( SELECT ROW_NUMBER() OVER (ORDER BY NO) RNO, NO FROM ROWNUM_TEST ) WHERE RNO <= 5 ORDER BY NO ; 取出中间 n 条记录 SELECT NO FROM ( SELECT ROW_NUMBER() OVER (ORDER... 阅读全文