SQL query to select one of each kind

Question

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 1

Not random representatives, but...

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