行列转换

SELECT name,max(case subject when ‘语文’ then score else 0 end) as ‘语文’,max(case subject when ‘数学’ then score else 0 end) as ‘数学’,max(case subject when ‘外语’ then score else 0 end) as ‘外语’ FROM score group by name

SELECT BUSIPART AS ‘营业部’,COUNT(*) AS ‘合计’,— 总数
SUM(CASE cp_type WHEN ‘0’ THEN 1 ELSE 0 END) AS ‘精英贷’ ,— 类别1
SUM(CASE cp_type WHEN ‘1’ THEN 1 ELSE 0 END) AS ‘薪水贷’ ,
SUM(CASE cp_type WHEN ‘2’ THEN 1 ELSE 0 END) AS ‘经营贷A’ ,
SUM(CASE cp_type WHEN ‘3’ THEN 1 ELSE 0 END) AS ‘经营贷B’ ,
SUM(CASE cp_type WHEN ‘4’ THEN 1 ELSE 0 END) AS ‘经营贷C’ ,
SUM(CASE cp_type WHEN ‘5’ THEN 1 ELSE 0 END) AS ‘物业贷’
FROM xs_tb_borrow
— WHERE ENTER_DATE BETWEEN ‘2014-01-01 00:00:00’ AND ‘2014-12-31 00:00:00’
— AND CP_TYPE=0 AND BUSIPART=110101
GROUP BY BUSIPART