Write a query to delete duplicate records in SQL SERVER
Answer Posted / chandran.s
Table Name: Example
Name Age
chandran 23
ranjith 24
chandran 23
To delete one of the duplicate records use following query
delete from example where age in(select age from example
group by age having count>1)
Is This Answer Correct ? | 13 Yes | 46 No |
Post New Answer View All Answers
Why are sql functions used?
What is the data type of time?
What is the use of sql profiler in sql server 2012?
What is the log shipping?
What are filegroups in sql server?
What is “asynchronous” communication in sql server service broker?
mention different types of relationships in the dbms?
What is for xml in sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is resultset concur_updatable?
How optimize sql query with multiple joins in sql server?
What do you understand by coalesce in sql server?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is ms sql server triggers?
How many columns can we include on clustered index ?