11.png
统计数据sql语句
SELECT name,count(*) FROM test
GROUP BY name;
数据结果
12.png
统计数据后排序
SELECT name,count(*) as count FROM test
GROUP BY name ORDER BY -name;
13.png
统计数据后筛选大于2的数据
SELECT name,count(*) as count FROM test
GROUP BY name HAVING count>2
14.png
使用having原因是:
HAVING子句通常与GROUP BY子句一起使用,以根据指定的条件过滤分组。如果省略GROUP BY子句,则HAVING子句的行为与WHERE子句类似。
python format用法详解
SQL HAVING 子句
原文:https://blog.csdn.net/a1007720052/article/details/81535757