SQL怎么统计分组后总共有多少列?

Question

select count(1),a from A ORDER BY a
这个不能统计分组后的,分组后的统计怎么做.?

Answer 1

SELECT COUNT(*), a FROM a GROUP BY a ORDER BY a;