group by:根据相同的字段进行分组,然后对每组数据进行处理。
结合之前的那个例子,表idandname
(1)根据相同name分组,显示id号和名称。
select id, name from idandname group by name;
+----+------+
| id | name |
+----+------+
| 1 | a |
| 2 | b |
| 3 | c |
+----+------+
3 rows in set (0.00 sec)
(2)根据相同的name分组,显示id号和名称,并且count相同name的个数
select id , name, count(name) from idandname group by name;
+----+------+-------------+
| id | name | count(name) |
+----+------+-------------+
| 1 | a | 1 |
| 2 | b | 2 |
| 3 | c | 2 |
+----+------+-------------+
3 rows in set (0.00 sec)