Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
44443
Starting Member
10 Posts |
 Posted - 2005-06-13 : 08:19:43
|
| Guys, I was wondering if there is a way to selct distinct combination of two columns in the select statementi.e.select distinct (col1, colb) from tableaI have tried this but it errors out, is there any other way that this can be doneThanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-06-13 : 08:25:32
|
select distinct col1, col2 from tableaGo with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
DISTINCT