Bogdan Kanivets Bogdan Kanivets - 10 months ago 34
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?


1 red

2 blue


Not random representatives, but...

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