select year,
m1 = sum(case when month = 1 then amonunt end),
m2 = sum(case when month = 2 then amonunt end),
m3 = sum(case when month = 3 then amonunt end),
m4 = sum(case when month = 4 then amonunt end)
from ta
group by year
m1 = sum(case when month = 1 then amonunt end),
m2 = sum(case when month = 2 then amonunt end),
m3 = sum(case when month = 3 then amonunt end),
m4 = sum(case when month = 4 then amonunt end)
from ta
group by year
m1=sum(case month when 1 then amonunt end),
m2=sum(case month when 2 then amonunt end),
m3=sum(case month when 3 then amonunt end),
m4=sum(case month when 4 then amonunt end)
from tb1
group by year结果:
1991-01-01 00:00:00.000 1.1 1.2 1.3 1.4
1992-01-01 00:00:00.000 2.1 2.2 2.3 2.4
m1 = sum(case when month = 1 then amonunt end),
m2 = sum(case when month = 2 then amonunt end),
m3 = sum(case when month = 3 then amonunt end),
m4 = sum(case when month = 4 then amonunt end)
from t
group by year