Bogdan Kanivets Bogdan Kanivets - 5 months ago 7
SQL Question

SQL query to select one of each kind

Let's say I have this table:

id colorName

1 red

2 blue

3 red

4 blue


How can I select one representative of each color?

Result:

1 red

2 blue

Answer

Not random representatives, but...

select color, min(id)
from   mytable
group by color;