I have a query that results in something like:

field 1 field 2
red blue
green black
blue red
orange black

What I want to do is make it so I only show distinct rows; however I want the distinction/uniqueness based on what's in field 1 and 2.
In other words, I would like the instance of red,blue(field1 ,field2)...