Having a bit of a mental block.
If I have a table like this:
How could return only the first occurence of the colour, along with the code?
I obviously can't to a group by because I have distinct codes.
Thanks in advance