Delete from Tbl where Id NOT IN( select Min(Id) from tbl Group By Colmn

how to delete duplicate rows in sql server2005

Question Posted / nittu

7 Answers
13427 Views
Cisco, CTS, HCL, IBM, I also Faced
E-Mail Answers

Answer Posted / nittu

Delete from Tbl where Id NOT IN(
select Min(Id)
from tbl
Group By Colmn1,Column2)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is DCL?

1041

What are the various editions of sql server 2017 that are available in the market?

888

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1845

Define cursor locking

989

How many types of stored procedures are there in sql server?

997

Explain the various types of concurrency problem?

1170

What is subquery? Explain the properties of a subquery?

976

what are defaults? : Sql server database administration

1076

What is cursors?

1168

Explain the dbcc pintable command when would you use it?

902

How to set the current database in ms sql server?

1068

How do you create a clustered index?

1042

In which format does an image save in SQL Server database ?

989

Explain view in sql server?

1049

Explain system functions or built-in functions? What are different types of system functions?

962