查找近五年年份

ORACLE

	SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2021', 'YYYY'), t.rn * 12), 'YYYY') YEAR FROM DUAL a,
	(SELECT (1 - ROWNUM) rn FROM DUAL d CONNECT BY ROWNUM <= 5) t