--case when then end 是对值进行改名处理
--别名是对列进行改名处理
select sum(n) total,
sum(case y
when '1987' then n
end )"1987",
sum( case y
when '1980' then n
end) "1980",
sum( case y
when '1982' then n
end )"1982",
sum( case y
when '1981' then n
end )"1981"
from
--别名是对列进行改名处理
select sum(n) total,
sum(case y
when '1987' then n
end )"1987",
sum( case y
when '1980' then n
end) "1980",
sum( case y
when '1982' then n
end )"1982",
sum( case y
when '1981' then n
end )"1981"
from
( select to_char(e.hiredate,'yyyy') y ,count(1) n from emp e group by to_char(e.hiredate,'yyyy'))