Write a query to delete duplicate records in SQL SERVER
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
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is the contrast between sql and mysql?
Explain what are commit and rollback in sql?
What does REVERT do in SQL Server 2005?
Do you know the capabilities of cursors?
What is for xml in sql server?
What happens if we shrink log file in sql server?
How to use subqueries in the from clause in ms sql server?
How will you find out if there are expensive SQL statements running or not?
Explain sql server service broker?
How does Report Builder support Analysis Services cubes?
What is a partition key?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is normalization? Explain its different types?
What are the differences between having and where clause.