Write a query to delete duplicate records in SQL SERVER
Answer Posted / prakash patel
delete from tbl_test where ID in
(select ID from tbl_test group by ID having count(ID) > 1)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Mention the differences between having and where clause.
Difference between 2NF &3NF ?
Is null vs coalesce?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What command would you use to add a column to a table in sql server?
What is encryption key?
What Are the Main Features of SQL Azure?
How to provide values to user defined function parameters?
When you should use a low fill factor?
What is save transaction and save point?
What are cursors and when they are useful?
How can sql server instances be hidden? : sql server security
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is database replication? What are the different types of replication you can set up in sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration