There is a table like this: tablename: example Name

Write a query to delete duplicate records in SQL SERVER

Question Posted / chandran

36 Answers
75365 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / chandran

There is a table like this: tablename: example

Name Age
chandran 23
ranjith 24
chandran 23

In this table the name:chandran and age:23 are the
duplicate records .so we need to delete this using this
sql statements

delete from example group by name,age having count>1

Is This Answer Correct ?

37 Yes

107 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happens when the SQL Azure database reaches Max Size?

107

What happens if time-only values are provided as date and time literals?

954

difference between Clustered index and non clustered index ?

936

What are the pre-defined functions in the sql server?

1030

What is data file in computer?

893

What are the acid properties?

946

What are scalar functions?

949

Is the log file is a part of file group?

976

Is port 1433 secure?

931

What is sql server profiler trace data file?

1052

What is a covered index?

893

Why use triggers?

969

List the different index configurations possible for a table?

884

What is the most common trace flags used with sql server?

965

What is the difference between varchar and nvarchar?

898