Mysql 行转列应用实例

表是一个单表，里面查出来的数据跟前台对应不上，只能行转列，以下是sql，可借鉴一下

SELECT hv_vioUnit,sum((case hv_vioCategory when ‘违反劳动纪律’ then 1 else 0 end)) As ‘违反劳动纪律’, sum((case hv_vioCategory when ‘违章指挥’ then 1 else 0 end)) As ‘违章指挥’, sum((case hv_vioCategory when ‘违章作业’ then 1 else 0 end)) As ‘违章作业’, sum((case hv_vioCategory when ‘其他’ then 1 else 0 end)) As ‘其他’,COUNT(hv_vioCategory) As zongji from hidden_violations where hv_status=‘0’ GROUP BY hv_vioUnit;