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

Does the order of columns in update statements matter?

493

What are the system database in sql server 2005?

560

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

599

wat wil hapn if we give the both read and deny read permission to user?

1660

List out the difference between union and union all in sql server?

529

What is log shipping?

574

Distinguish between commit and rollback?

560

What are data resources?

514

What are magic tables in sql server?

638

What’s the use of custom fields in report?

573

Determine when an index is appropriate?

572

Tell me extended events in sql server 2008?

567

How to restore performance issues and how to check?

1529

How do you delete a data source?

566

Differentiate between a local and a global temporary table?

553