Delete duplicate records from the table?(Table must have
unique id)
Answer Posted / naren
delete id from table where id in(select id from table having count(id)>1)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is sqlservr.exe - process - sql server (sqlex?press)?
How to execute stored procedure and set temp table in sql server?
When would you prefer to have a minimum number of indexes?
What is difference between inner join and full join?
What is collation sensitivity?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Explain data warehousing in sql server?
What is an sql server agent?
What gets stored inside msdb database?
How do I setup a local sql server database?
How to delete database objects with "drop" statements in ms sql server?
How would you choose between a clustered and a non-clustered index?
What is difference between foreign key and unique key?
What are different types of statements that are supported by sql?
What does it mean to be in union?