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 are Spatial data types in SQL Server 2008
What are subquery and its properties?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How can delete duplicate records in cte in sql server?
What is the stored procedure?
What is sub-query in sql server?
Where are sql server usernames and passwords stored in the sql server?
In what three ways is the return statement used in a stored procedure?
Explain syntax for disabling triggers?
What are types of storage modes? : sql server analysis services, ssas
If user is owning any SQL Objects, can we drop that user
What are the security related catalog views? : sql server security
What is a mutating table error and how can you get around it?
Is it possible to update the views? If yes, how, if not, why?
Tell me what is de-normalization and what are some of the examples of it?