How I fetch values from one column based on distinct values from other column?

Question

I have two columns in a table and I want a query to fetch First column values based on distinct values from Second column. Since, There are multiple combinations of First and second column I would like to have the first match from each combination.

DATASET:

First Column	Second Column
A	abc
B	abc
C	abc
D	abc
F	abc
G	abc
H	qwe
I	qwe
J	jkl
K	jkl
L	jkl
M	uio
N	uio

Excepted Output:

First Column	Second Column
A	abc
H	qwe
J	jkl
M	uio

Just use `MIN(col1)` and `GROUP BY col2`. This is beginner SQL. — Barmar, Aug 27 '21 at 02:53
It doesn't matter what it contains. `GROUP BY col2` works with any datatype. — Barmar, Aug 27 '21 at 02:55
I don't understand what you mean. `MIN(col1)` is what selects the first value from the first column in each group. — Barmar, Aug 27 '21 at 02:59

score 2 · Accepted Answer · answered Aug 27 '21 at 02:57

2

Just use MIN() and GROUP BY.

SELECT min(`First Column`) AS `First Column`, `Second Column`
FROM yourTable
GROUP BY `Second Column`

DEMO

answered Aug 27 '21 at 02:57

Barmar

741,623
53
500
612

How I fetch values from one column based on distinct values from other column?

1 Answers1