MySQL 分组查询、聚合查询与联合查询 | 极客日志

MySQL 分组查询、聚合查询与联合查询 | 极客日志

select count([distinct] col) from tb_name;

select sum([distinct] col) from tb_name;

select avg([distinct] col) from tb_name;

select max([distinct] col) from tb_name;

select min([distinct] col) from tb_name;