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 many types of stored procedures are there in sql server?
How to create and drop temp table in sql server?
What are different types of raid levels?
What is the difference RDBMS and Graph Database?
What are the properties of the transactions?
What is blocking and how would you troubleshoot it? : sql server database administration
What is the full form of dql?
What is store procedure? How do they work? When do you use?
What is the dbcc command and why is it used?
What is resource governor in sql server?
Where are stored procedures in sql server?
How can I check if a view exists in a sql server database?
What is stored in the mssqlsystemresource database? : sql server database administration
Which is the best place or learning center for MS SQL?????In Bangladesh?????
is it important for a database administrator to understand the operating system and file access? : Sql server administration