05检索数据 · 数据分析强化辅导

![](https://img.kancloud.cn/1b/c2/1bc27fefacf359042550b2249d4d108e_1280x720.png) ![](https://img.kancloud.cn/3c/a6/3ca6a4667466cb158ab3da2773879e1a_1280x720.png) ![](https://img.kancloud.cn/1b/c2/1bc27fefacf359042550b2249d4d108e_1280x720.png) ![](https://img.kancloud.cn/a9/bb/a9bbd9fae6b23b6db0ab213aad8f701f_1280x720.png) ![](https://img.kancloud.cn/5f/ca/5fcac2925f2bf4e8981d456cdc17aa35_1280x720.png) ![](https://img.kancloud.cn/6b/d8/6bd8d117c00c24e8873b495b913897b5_1280x720.png) ![](https://img.kancloud.cn/65/92/659251147bec1341b756da9c1a92d440_1280x720.png) ![](https://img.kancloud.cn/c6/75/c6756182cbf4c36797040bcf6deb5380_1280x720.png) 表名区分大小写分组后，聚集函数作用于每个组。如avg和count 显示表中唯一值用group by的速度比用distinct的速度快。 having count(*) >10 的意思是筛选出组内条目数>10的组 having avg(*) > 50000,保留平均数 > 50000的组