select distinct one column and pick just one occurence out of the second one-CodePudding

Home > other > select distinct one column and pick just one occurence out of the second one

select distinct one column and pick just one occurence out of the second one

Time：06-15

I have the below data:

I want to select distinct id1. For id2, I just want the first occurrence - I don't care about the rest like this:

id1	id2
1	a
2	c

Thanks!

CodePudding user response：

Should be fairly simple:

select id1, min(id2) as id2
from that_table
group by id1