Write a query to delete duplicate records in SQL SERVER
Answer Posted / dharmesh
your table look like this and want to delete duplicate
record
chandran 23
ranjith 24
chandran 23
delete top(1) from tablename where name='chandran' and
age=23
| Is This Answer Correct ? | 3 Yes | 28 No |
Post New Answer View All Answers
What is the difference between grant and with grant while giving permissions to the user?
Why we use the openxml clause?
What is the difference between locking and multi-versioning?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Explain system views?
What is fill factor and pad index?
What are the mathematical functions supported by sql server 2005?
What is transaction server implicit?
How much memory that we are using in Logshipping Concept?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What do you know about system database? : SQL Server Architecture
Is it possible to replicate data from sql server to oracle? : sql server replication
What is the purpose of indexing?
how you can move data or databases between servers and databases in sql server? : Sql server administration
How to delete an existing database user?