I am trying to do the same thing. The answer provided does not really address the issue. I want ALL the columns in a row; but wish to purely do a distinct(col1). Of course you could do a join on the table containing only the distinct column with the original table but even then you would get multiple rows with multiple records from this table. It is weird that an option does not exist to select a column(s) for the distinct keyword other than writing code.
... View more