My SQL 一维变二维_CDA答疑社区

热线电话：13121318867

登录

1530553748

2020-06-04 阅读量: 867

My SQL 一维变二维

#方法一if

select s_id,c_id,sum(if(c_id='01',score,0)) '01',sum(if(c_id='02',score,0)) '02',sum(if(c_id='03',score,0)) '03' from score group by s_id;

select s_id,max((c_id='01')*score) '01',max((c_id='02')*score) '02',max((c_id='03')*score) '03' from score group by s_id;

# G方法二

select *,max(c_id='01')*score '01',max(c_id='02')*score as '02',max(c_id='03')*score as '03' from score group by s_id;

15.2822

1

2

关注作者

收藏

评论(0)

发表评论

暂无数据

CDA考试动态

CDA报考指南

推荐帖子