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 |
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
Tamaradenise
Starting Member
7 Posts |
Posted - 2014-12-24 : 13:45:06
|
Thank you Tamara |
|
|
|
|
|