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
What's the information that can be stored inside a bit column?
What is stored in the mssqlsystemresource database? : sql server database administration
How to restore performance issues and how to check?
How can we delete a table in sql server?
What are the types of ssrs?
What type of Index will get created after executing the above statement?
What is history table in sql server?
What is 1nf 2nf and 3nf?
Where do you find the default Index fill factor and how to change it?
What is a coalesce function?
List the different index configurations possible for a table?
Explain the disadvantages of cursors?
Explain what are the database objects? : SQL Server Architecture
Define Business Edition in SQL Azure?
if no size is defined while creating the database, what size will the database have? : Sql server administration