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 |
|
nicki_assumption
Yak Posting Veteran
69 Posts |
 Posted - 2006-02-26 : 14:42:26
|
| Hi, I think you can do this in oracle but I'm trying to figure a way to do it in ms sql.. I need to select a distinct combination of columns, like so...select distinct(ItemName,ItemData,FID) from tblSIFups Does anyone know how to achieve that? I have multiple data where I shouldn't and I don't have any control over the application so I need to clean it this way.thanks, nicki |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-02-26 : 15:08:43
|
| SELECT DISTINCT ItemName, ItemData, FID FROM tblSIFups |
 |
|
|
|
|
|
selecting distinct on 3 columns in ms sql server