The table looks like this:
Expand|Select|Wrap|Line Numbers
- id color
- --- ------
- 3 red
- 4 red
- 5 blue
- 6 green
- 7 red
- 8 blue
- 9 green
I tried playing around with SELECT DISTINCT but I can't seem to get the id to return with the distinct results. Examples:
SELECT DISTINCT color FROM table
Returns:
Expand|Select|Wrap|Line Numbers
- color
- ------
- red
- blue
- green
SELECT DISTINCT color, id FROM table
Returns my original result (since all ids are distinct)
and I'm looking for a way to arrive at this:
Expand|Select|Wrap|Line Numbers
- id color
- --- ------
- 3 red
- 5 blue
- 6 green