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
声明:本文来自网络,不代表【好得很程序员自学网】立场,转载请注明出处:http://haodehen.cn/did118352
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
上一篇: MYSQL语法篇之"WHERE"子句
下一篇:数据库查询语句(DQL)