DELETE FROM MyTable WHERE ID IN ( SELECT MAX(ID) FROM MyTable GROUP B

Delete duplicate records from the table?(Table must have
unique id)

Question Posted / lince

Answer Posted / lince

DELETE
FROM MyTable
WHERE ID IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1 HAVING COUNT(ID)>1
)

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many triggers are possible per table?

1098

What are the difference between clustered and a non-clustered index?

1043

Can sql servers linked to other servers?

1046

what are the new features in SSRS?

134

What are sub reports?

201

Explain what is public role in sql server?

1135

What is serializable?

1044

What is Service Broker in sql server 2012?

1021

Explain the concept of recursive stored procedure.

963

How to invoke a trigger on demand?

1092

How to include text values in sql statements?

1040

What is default constraint in ms sql server?

1037

Explain microsoft sql server functions?

1117

What is set nocount on and what is set nocount off?

934

What stored by the msdb?

1000