MySQL 使用gourp by分组查询之后如何统计记录条数 count()

统计

SELECT count(*) FROM 表名 WHERE 条件 // 这样查出来的是总记录条
SELECT count(*) FROM 表名 WHERE 条件 GROUP BY id //这样统计的会是每组的记录条数.

如何获得 group by 的总记录条数

SELECT arrival_number FROM mobile_brand WHERE company_id = 23 ORDER BY arrival_number DESC LIMIT 7

结果：

select sum(arrival_number) as number from (SELECT arrival_number FROM mobile_brand WHERE company_id = 23 ORDER BY arrival_number DESC LIMIT 7) as subt;

结果：