count(*) sum avg max min
基本使用语法:
select max(age) from t_student group by class_id;
select min(age) from t_student group by class_id;
聚合函数经常会结合分组查询,出现在众多的SQL笔试题中
count(*) sum avg max min
基本使用语法:
select max(age) from t_student group by class_id;
select min(age) from t_student group by class_id;
聚合函数经常会结合分组查询,出现在众多的SQL笔试题中