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

Define full outer join in sql server joins?

971

What is meant by datasource?

917

Comment,Datatypes are unlimited

2055

Where actually sql azure database is hosted?

163

How to recover from sql injection? : sql server security

1005

Describe different Processing Modes offered by SSRS?

248

Explain some stored procedure creating best practices or guidelines?

924

What is an index in sql?

995

What do you understand by a stored procedure?

1088

How to delete duplicate rows in sql server?

1092

What is sql server english query?

1111

Explain the rules for designing files and file groups in sql server?

978

What is the sql server 2000 version number?

1072

What is Sqlpaging in SqlServer 2005 ?

1055

What are the properties and different types of sub-queries?

1005