Unique 1

[jmob]

I have a table A
ID | Type
1 1
1 1
1 2
2 1
2 1
3 1
3 2
3 3
3 4
There are two columns. I am looking to get only the unique combinations:
ID | Type
1 1
1 2
2 1
3 1
3 2
3 3
3 4
Thanks. Man I'm going to have to start looking for my sql book lying around! Thanks ahead of time.

 

[PHV]

SELECT DISTINCT A.ID, A.Type FROM [table A] AS A;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886