Code: Select all
A1 B11
A1 B12
A1 B13
A1 B14
A1 B15
A2 B21
A2 B22
A2 B23
and so on..Code: Select all
A1 B11
A2 B21
A3 B31Thanks.
Moderator: General Moderators
Code: Select all
A1 B11
A1 B12
A1 B13
A1 B14
A1 B15
A2 B21
A2 B22
A2 B23
and so on..Code: Select all
A1 B11
A2 B21
A3 B31Code: Select all
SELECT distinct(a.value), min(b.value) FROM a
WHERE a.related_key = b.related_key