主页 > Mysql > mysql group by having的使用方法
查询出test表中,同名个数大于2的所有记录。 select name,count(name) as num from test group by name having count(name)>=2;
评论已关闭.