select distinct 对单列去重，并取其他列第一行结果

所有数据

create table abc(id int, value int);
select id, value from abc;
+------+-------+
| id   | value |
+------+-------+
|    0 |     0 |
|    1 |     0 |
|    2 |     1 |
|    3 |     2 |
|    4 |     4 |
+------+-------+

value 去重

select distinct value from abc;
+-------+
| value |
+-------+
|     0 |
|     1 |
|     2 |
|     4 |
+-------+

select distinct value, id from abc;
+-------+------+
| value | id   |
+-------+------+
|     0 |    0 |
|     0 |    1 |
|     1 |    2 |
|     2 |    3 |
|     4 |    4 |
+-------+------+

select id, distinct value from abc;
语法报错

对 value 去重，id 取第一行

select min(id), value from abc group by value;
+---------+-------+
| min(id) | value |
+---------+-------+
|       0 |     0 |
|       2 |     1 |
|       3 |     2 |
|       4 |     4 |
+---------+-------+

故如果要对某一列 (value) 去重，且保留其他列，则需要用 group 和 min/max 配合使用。