SELECT DISTINCT for two columns be get all the data.
Posted on 2007-03-24
I have 5 columns, A,B,C,D, and E.
THere are possible duplicates only in column A and B. I want to create a new table that has only unique values based on A & B, but has all the columns of data. (i.e., On a given row, x, the values of A and B are not the same as any other row's A and B column).
I tried, SELECT DISTINCT A,B FROM list; but it is not an option as it only gives me columns A and B.
How do I get all the columns where columns A & B are DISTINCT?