mysql常用算法积累
1、mysql计算百分比使用sum函数,如下:SELECT COUNT( * ) AS 总数, SUM( CASE WHEN `匹配情况` = 1 THEN 1 ELSE 0 END ) AS 总匹配数, SUM( CASE WHEN `匹配情况` = 1 THEN 1 ELSE 0 END ) / COUNT( * ) * 100 总准确率, SUM( CASE WHEN `投诉回复` = "无...
原创
2018-06-06 16:35:34 ·
1861 阅读 ·
0 评论