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 |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2003-12-18 : 17:28:11
|
| i have a table with an id and one other field. if i want to select just the distinct other field and the id field, how would that go? i tried 'select distinct(other),id from tablename' but that returns all of them |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-18 : 17:42:27
|
| SELECT MAX(id), otherFROM Table1GROUP BY otherIf that isn't what you want, please provide a simple example of what the data looks like and what the query should return.Tara |
 |
|
|
|
|
|
simple tsql problem