select sum(sal) as sum from salary where sname='张三' and sdate >=trunc(sysdate,'YYYY') -- 今年的总工资
--- select sal from salary where sname='张三' group by sdate,sal having sdate >=trunc(sysdate,'YYYY-mm') -- 每月的工资
我看一张表不能够完成你所得到的答案,工资既然有发放的类型不通,就要重新设计
求出今年的总工资
select sum(sal) from salary where sname='张三' and to_char(sdate,'yyyy') = to_char(sysdate,'yyyy')
求出每月的工资
select sum(sal),to_char(sdate,,'yyyy-MM') from salar where sname='张三' group by to_char(sdate,,'yyyy-MM')