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 |
|
sathishgforum
Starting Member
1 Post |
 Posted - 2003-07-02 : 07:47:20
|
| Hai All, I want to know the query that deletes the duplicate records in sql2000. (For example in the table i dont have the primary key,identity so i have repeated records with the same values, i would like to delete the duplicate records and remain the other records as well in the table). Using Distinct is not the solution for this problem,coz i have to delete the repeated records permenantly from the existing table. Hope i will get the best answer through your help.Thanks in advance.Have a nice day. Regards SATHISH KUMAR |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-02 : 07:51:08
|
| Read the SQL Team FAQ:http://www.sqlteam.com/FAQ.aspAnd yes, using DISTINCT is the answer, you just need to work with it a little more. |
 |
|
|
|
|
|
How to eliminate the duplicate records