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
what is the difference between openrowset and openquery?
What is standby servers? Explain types of standby servers.
How can I check that whether automatic statistic update is enabled or not?
What are the kinds of subquery?
do you know how to configure db2 side of the application? : Sql server database administration
What kind of problems occurs if we do not implement proper locking strategy?
How efficient you are in oracle and SQL server?
What is sql or structured query language?
What are different types of constraints?
List out the different types of locks available in sql server?
Can sql servers link to other servers like oracle?
Can you index views?
Is it possible to have clustered index on separate drive from original table location?
What are the source of constraints?
Can we shrink data file in sql server?