'Only fetch unique records' option doesn't return unique records. (4285317)

I have a table with 3 columns and only column two has repeat records.

COL1    COL2    COL3
1            HELLO  Monday
2            HELLO  Tuesday
3            BYE        Wednesday

In the Query Builder, I checked 'Only fetch unique records' and created the following query

SELECT DISTINCT T.COL1, T.COL2, T.COL3
  FROM SQL2008SBS.dbo.Table T 

When I execute it, it did not bring back distinct results for column 2.  I'm still get the following:

COL1    COL2    COL3
1            HELLO  Monday
2            HELLO  Tuesday
3            BYE        Wednesday

DISTINCT applies to all the columns you want to bring back in the query. So even though you have one column with repeat data, the entire row may still be unique given the other columns.  In the above example

"1 HELLO Monday" is not the same as "2 HELLO Tuesday"