Is it possible to select items where only one column needs to be distinct?
SELECT DISTINCT Col1, Col2, Col3 FROM TABLE
will select columns where all three are distinct, am I correct in that?
How would I select all records where we only have Col1 distinct?
