**表一 聚合函数 SELECT name,count(*) FROM test GROUP BY name; select name,count() from test group by name having count()>2;