Bayt.com

Trending MS SQL Server 2005 Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
SQL
MS SQL Server 2005
Muhammad Hammad Javaid's image
Question added by Muhammad Hammad Javaid IT Project Manager Dubai Islamic Bank
11 years ago

I have multiple records in a table and do not have any primary key/ unique key. How to delete duplicate records keeping actual records?‎

Answers:
1
Followers:
Views:
118
Vote Count:
1
Report Inappropriate
Answer should contain a minimum of 25 characters.
SQL
MS SQL Server 2005

I have multiple records in a table and do not have any primary key/ unique key. How to delete duplicate records keeping actual records?‎

Default profile image  
Answer added by  Deleted user
11 years ago

its better to have a unique key at least on one of the tables, but if not you have to: 1- get the results from table 1 2- get results from table 2 3- store both results i ... See More

Downvote
Report Inappropriate