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)
 Getting rid of duplicate rows without using distinct

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-06-21 : 22:00:41
Sara writes "I have been told that using distinct can cause performance problems or something like that. Is there a way to get around using distinct? I've tried using group by, but you have to have your entire select statement in the group by, and that just looks horrible. I need help! Thanks!"
   

- Advertisement -