统计一个 重复名称出现的次数

统计一个  重复名称出现的次数

select sname,count(sname) as count from test group by sname HAVING count = 3

 

转“https://zhuanlan.zhihu.com/p/104764586”