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 if the update subquery returns no rows in ms sql server?

1072

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

974

Can you explain the disadvantages/limitation of the cursor?

906

What is a user-defined function in the sql server and what is its advantage?

1043

Explain primary key in sql server?

970

How to add more data to the testing table in ms sql server?

999

Do you know the isolation level that sql server support?

920

Can sql server 2016 run on windows 7?

860

What are the 3 types of schema?

1041

how you can configure a running aggregate in SSRS?

184

What are xml indexes?

891

What are the five major components of a dbms?

880

List out the differences between the clustered index and non-clustered index in sql server?

943

Define inner join? Explain with an example?

923

How to create and drop temp table in sql server?

1001