sql的一些实验

表内容

1 . 执行   SELECT `name` from yourtable   GROUP BY `name`;

结果1：

2.执行   SELECT `name` from yourtable   GROUP BY `name` HAVING COUNT(`name`)>2 ;   #group by 要与having一起使用

结果2:

3.执行 SELECT `name` from yourtable  group by `name` HAVING COUNT(`name`)>1 order BY `name` DESC;

结果3：