表Table1
num name
1 a
2 a
5 a
2 b
6 b
7 b
8 b
2 c
3 c
5 c
6 d
目标:
num name
1 a
2 b
2 c
6 d
--------------
SELECT min(id), name
FROM TABLE1 group by a
num name
1 a
2 a
5 a
2 b
6 b
7 b
8 b
2 c
3 c
5 c
6 d
目标:
num name
1 a
2 b
2 c
6 d
--------------
SELECT min(id), name
FROM TABLE1 group by a