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's new in sql server 2016?
According to you what goes into making the best database administrator? : sql server database administration
What you can do to delete a table without the delete trigger firing?
Show Practically Sql Server Views are updatable?
How can I create a report based on a query? : sql server management studio
Can we hide the definition of a stored procedure from a use?
What is self contained sub query?
What do you understand by integration services in sql server?
How to drop an existing schema in ms sql server?
How many types of triggers in sql server?
What do you understand by triggers and mention the different types of it?
How to assign new column names in a view?
What is the full form of ddl?
What are the components of dbms?
How do I run sql server 2014?