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
Can you edit the .rdl code associated with a linked report?
What is the purpose of indexing?
What is create command?
How many types of cursor type are there?
How can I track the changes or identify the latest insert-update-delete from a table?
can you instantiate a com object by using t-sql? : Sql server database administration
What are the different types of Indexes available in SQL Server?
Where to find ntwdblib.dll version 2000.80.194.0?
Explain filtered indexes benefits?
Give a example to search fr a string in all stored procedure in sql server.
What do you understand by user-defined function in the sql server?
What is the difference between value type and reference type?
Difference between connected and disconnected database in .net with sql server?
What is it’s similarity with sql server?
How to defragment indexes with alter index ... Reorganize?