select count(id) as count1,name from q1 where (select count(id) from q1 as m where m.name=q1.name)>2 group by name order by count(id) desc
我看不太懂这个SQL,这么多个where,请大家会的帮我解析下,谢谢

明白一些了!看到别人程序中的SQL语句,看不太明白,所以问一下的! 谢谢!