delete from tbl_test where ID in (select ID from tbl

Write a query to delete duplicate records in SQL SERVER

Question Posted / prakash patel

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

Please Help Members By Posting Answers For Below Questions

What's the information that can be stored inside a bit column?

1007

What is stored in the mssqlsystemresource database? : sql server database administration

1035

How to restore performance issues and how to check?

2005

How can we delete a table in sql server?

979

What are the types of ssrs?

145

What type of Index will get created after executing the above statement?

1102

What is history table in sql server?

974

What is 1nf 2nf and 3nf?

891

Where do you find the default Index fill factor and how to change it?

1064

What is a coalesce function?

1199

List the different index configurations possible for a table?

935

Explain the disadvantages of cursors?

1144

Explain what are the database objects? : SQL Server Architecture

1086

Define Business Edition in SQL Azure?

100

if no size is defined while creating the database, what size will the database have? : Sql server administration

1010