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
 General SQL Server Forums
 New to SQL Server Programming
 delete statement please help

Author  Topic 

Tamaradenise
Starting Member

7 Posts

Posted - 2014-12-24 : 13:20:31
Write a delete statement to remove the duplicates on PATIENT_ID. It does not matter which duplicates are deleted but the table must be unique on PATIENT_ID after the delete statement.

Tamara

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-24 : 13:43:24
Search for "deleting duplicates" here on SQLTeam or "deleting duplicates in SQL" on google. This is a widely covered topic and not something we need to re-hash.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Tamaradenise
Starting Member

7 Posts

Posted - 2014-12-24 : 13:45:06
Thank you


Tamara
Go to Top of Page
   

- Advertisement -