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 2000 Forums
 SQL Server Development (2000)
 Selecting distinct rows

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-12 : 09:27:59
Gary writes "I wish to select all records from a table however there will be numerous records that have the same id in one of the columns. I don't want any records with the same id.

I know i can do select distinct expertid form experts, however this only gets my the expertid, i want to see all the other data in this table as well.

I hope this makes some sense"
   

- Advertisement -