17,382
社区成员




SELECT substr(MONTH, 1, 4) "年", SUM(Gongzi) "工资总和", SUM(JiangJin) "奖金总和"
FROM YOURTAB
GROUP BY substr(MONTH, 1, 4)
select TO_CHAR(MONTH,'YYYY') AS 年,
SUM(Gongzi) AS 工资总和 ,
SUM(JiangJin ) AS 奖金总和
FROM YOURTAB
GROUP BY TO_CHAR(MONTH,'YYYY')