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

Best Solution

Not random representatives, but...

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