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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Query with distinct

Author  Topic 

skiabox
Posting Yak Master

169 Posts

Posted - 2009-03-24 : 07:46:21
I have a query of the type
SELECT * FROM table WHERE id=551
and I get some results from this one.
How can I get from these results the distinct rows using another field?(not id).
Thank you!

asgast
Posting Yak Master

149 Posts

Posted - 2009-03-24 : 07:55:18
SELECT DISTINCT * FROM table WHERE id=551
Go to Top of Page
   

- Advertisement -