You have Two option You can use keyword Distinct or Group By Both will help

Write a query to delete duplicate records in SQL SERVER

Question Posted / anuj

Answer Posted / anuj

You have Two option You can use keyword Distinct or Group By Both will help you to delete dublicate records

Is This Answer Correct ?

1 Yes

11 No

Please Help Members By Posting Answers For Below Questions

how can u get last observation in an unknown dataset ?

2485

What is code near application topology?

283

How to recompile stored procedure at run time?

1116

Explain how many types of relationship?

1084

What are different types of views?

985

Explain about extended stored procedure?

993

How to configure and test odbc dsn settings?

1224

tell me the disaster recovery plan

2561

Do you know how to store and query spatial data?

1087

How to get the number of affected rows?

1053

What is collation sensitivity? Explain different types.

1054

What happens if the update subquery returns no rows in ms sql server?

1174

How to defragment table indexes?

1038

What do you mean by subquery?

1145

What are the new security features added in sql server 2012? : sql server security

1106