总结:1.case when CASE WHEN条件表达式函数:类似JAVA中的IF ELSE语句。可以参考(https://blog.csdn.net/rongtaoup/article/details/82183743)
2.GROUP BY with rollup(详情可至:https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html)
总结:1.case when CASE WHEN条件表达式函数:类似JAVA中的IF ELSE语句。可以参考(https://blog.csdn.net/rongtaoup/article/details/82183743)
2.GROUP BY with rollup(详情可至:https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html)