实现:通过"group by"关键字
语法:group by 字段
示例:select deploy_env_name,count(deploy_env_id) '云服务商数' from system_area_global where delete_status='NORMAL' group by deploy_env_id,deploy_env_name;
解释:根据deploy_env_id,deploy_env_name字段进行分组,然后使用count函数统计deploy_env_id数量