sql group by 与sum
今天用到了个统计,记得以前写过,但是猛然好像忘记了,在此记录一下,也分享给需要的小伙伴。SELECT item1_id,result,SUM(CASE WHEN result = '1' THEN 1 ELSE 0 END) as r1 ,SUM(CASE WHEN result ='2' THEN 1 ELSE 0 END) as r2,SUM(1) as total FROM `test...
原创
2019-05-23 15:17:30 ·
7177 阅读 ·
1 评论