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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-07 : 09:04:59
|
| Danny writes "How do I return more than one column when using SELECT DISTINCT, without the extra columns being included in the 'DISTINCT' part?eg.SELECT DISTINCT col1, col2, col3 FROM tableChecks col2 and col3 are distinct too, whereas I just want distinct col1's!I'm using MS SQL Server." |
|
|
|
|
|
SELECT DISTINCT