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 |
Advertisement
Answer
Just use MIN()
and GROUP BY
.
SELECT min(`First Column`) AS `First Column`, `Second Column` FROM yourTable GROUP BY `Second Column`