mysql - Mysql GROUP BY with MAX(DATE) and MIN (DATE)

Question

在我的 mysql 表中，我有一个日期列和一个票证列：

+------------+------------+
| Ticket     | Date       |
+------------+------------+
| 1          | 2020-02-02 |
| 1          | 2020-03-03 |
| 1          | 2020-04-02 |
| 2          | 2020-04-05 |
| 2          | 2020-04-09 |
| 2          | 2020-04-15 |
+------------+------------+

如何为每张票选择一个查询 min(DATE) 和 max(DATE)，结果应该是：

+------------+------------+------------+
| Ticket     | MIN Date   | MAX DATE   |
+------------+------------+------------+
| 1          | 2020-02-02 | 2020-04-02 |
| 2          | 2020-04-05 | 2020-04-15 |
+------------+------------+------------+

标签： mysqlsqlgroup-bymaxmin

Answer 1

这是简单的聚合：

select ticket, min(date) mindate, max(date) maxdate
from mytable
group by ticket