Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 67702 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
How do you set a trace flag in sql server?
Explain can SSRS reports Cache results?
What is a livelock?
What is difference between order by and group by?
What is log ldf?
What is an active database?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
How to implement service broker?
What is pessimistic concurrency?
What is 'Join' and explain its various types.
What is a scheduled job or what is a scheduled task?
what exactly sql injuction.how to overcome.....
Write a query to find 5th highest amount paid from the customer table.
How do you Implement SSIS Packages in your Project?
How do I view views in sql server?
