Write a query to delete duplicate records in SQL SERVER
Answer Posted / ashish kumar
select * from dbo.duplicatetest
set rowCount 1
delete from dbo.duplicatetest where iD=1;
set rowCount 0
Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
How you can move data or databases between servers and databases in sql server?
What is tcl in sql server?
What is the difference between deallocate cursor and close cursor?
What is the difference between dropping a database and taking a database offline?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is raid and what are different types of raid levels?
What is save transaction and save point?
What is difference between equi join and natural join?
What is the parse query button used for?
Explain throw statement in sql server 2008?
Why de-normalization required?
what happens on checkpoint? : Sql server database administration
How to drop an existing table?
How to join two tables in a single query in ms sql server?
What different steps will a sql server developer take to secure sql server?