17,140
社区成员




SELECT AVG(SAL),TO_CHAR(YEAR)||LPAD(MONTH,2,0)
FROM A
WHERE TO_CHAR(YEAR)||LPAD(MONTH,2,0)>=TO_CHAR(ADD_MONTH(SYSDATE,12),'YYYYMM')
GROUP BY TO_CHAR(YEAR)||LPAD(MONTH,2,0);
SELECT AVG(SAL),TO_CHAR(YEAR)||LPAD(MONTH,2,0)
FROM A
WHERE TO_CHAR(YEAR)||LPAD(MONTH,2,0)>=TO_CHAR(ADD_MONTH(SYSDATE,12),'YYYYMM')
GROUP BY TO_CHAR(YEAR)||LPAD(MONTH,2,0);
SELECT AVG(SAL),TO_CHAR(YEAR)||LPAD(MONTH,2,0)
FROM A
WHERE TO_CHAR(YEAR)||LPAD(MONTH,2,0)>=TO_CHAR(ADD_MONTH(SYSDATE,12),'YYYYMM')
GROUP BY TO_CHAR(YEAR)||LPAD(MONTH,2,0);