select year,
sum(case when jidu =1 then mount end )as '1季度',
sum(case when jidu =2 then mount end )as '2季度',
sum(case when jidu =3 then mount end )as '3季度',
sum(case when jidu =4 then mount end )as '4季度'
from selecttest group by year
sum(case when jidu =1 then mount end )as '1季度',
sum(case when jidu =2 then mount end )as '2季度',
sum(case when jidu =3 then mount end )as '3季度',
sum(case when jidu =4 then mount end )as '4季度'
from selecttest group by year