SELECT * FROM ( SELECT R.*, ROWNUM RN FROM ( SELECT A .*, b.org_name FROM INDEX_FINANCE_BUDGET A LEFT JOIN SYS_ORG b ON A .org_id = b. ID WHERE A .del_flag = ‘0‘ AND A .index_type = ‘productOutput‘ ORDER BY A .cdate DESC ) R ) R2 WHERE R2.RN > 0 AND R2.RN <= 15
原文:https://www.cnblogs.com/tangshengwei/p/12296681.html