2020-09-07 阅读量: 870
问题：
解答：
select cus_id,sum(case acc_type when 'checking' then acc_no else null end) as 'checking account',
sum(case acc_type when 'saving' then acc_no else null end) as 'saving account'
from t_a
group by cus_id;
用到case..when ..then..else语句
