Let's say I have a table like this:
name_1 name_2 value
-------------------
john alex 6
alex john 6
bob rick 7
rick bob 7
I want to get rid of the duplicates so I'm left with this:
name_1 name_2 value
-------------------
john alex 6
rick bob 7
Does distinct work? And if so, how would I apply it?
EDIT:
I'm not concerned about the order of the names in the final table. I am looking for name pairs. So I am treating john alex the same as alex john. Therefore, I want to get rid of those "duplicates"