当用select*from 表名 group by ‘字段名1’ 将选出来的内容将按照字段1分组,其他列不尽相同,会以最前面的内容显示:
GROUP BY 后面可以跟多个列名,表示以多列作为分组依据:mysql> select `name`,`date`,count(*) from `employee_tbl` group by `name`,date;
+------+---------------------+----------+
| name | date | count(*) |
+------+---------------------+----------+
| 小丽 | 2016-04-19 15:26:02 | 1 |
| 小明 | 2016-04-04 15:26:54 | 1 |
| 小明 | 2016-04-11 15:26:40 | 1 |
| 小明 | 2016-04-22 15:25:33 | 1 |
| 小王 | 2016-04-07 15:26:14 | 1 |
| 小王 | 2016-04-20 15:25:47 | 1 |
+------+---------------------+----------+
6 rows in set (0.05 sec)
group by 后可以跟with