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

What happens to a statement batch if there is a compilation error?

971

What is triggers and its types?

1011

Can we use where and having clause together?

1050

How do I shrink an ldf file?

983

When I run the sql server 2000 setup, it just hangs. What do I do?

1089

What Is Rdbms?

1169

What is the difference between migration and upgradation in sql server?

1101

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1142

Explain some stored procedure creating best practices or guidelines?

941

Why are you getting errors when creating a new odbc dsn?

1227

How do you Implement SSIS Packages in your Project?

1933

how many triggers you can have on a table? : Sql server database administration

983

What are different types of roles provided by ssrs?

152

How can I know what locks are running on which resource?

957

Do you know what is bit data type and whats the information that can be stored inside a bit column?

961