Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 77498 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
where the connection string store in the database
Does a server store data?
What is SubQuery in SQL Server 2008
What is lock escalation and what is its purpose?
What is a print index?
What is purpose of normalization?
What are “lost updates”?
What is sleeping status in sql server?
Explain about Joins?
What is a recursive stored procedure in sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are the different types of triggers in SQL SERVER?
Do you know what is replace and stuff function in sql server?
What are the character string functions supported by sql server 2005?
What are the advantages of using stored procedures?
