mysql分组查询和排序

user_name from t_user group by user_name order by id

select sex,avg(math) ,count(id) ID from student group by sex having ID>2;  --ID是别名

 

mysql分组查询和排序

标签：span   nbsp   group by   where   class   函数   math   group   user