How to delete the duplicate rows from a table in SQL Server ??
Answer Posted / sudha511
select distinct * into #temp from sampletbl
delete sampletbl
insert into sampletbl
select * from #temp
drop table #temp
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why truncate is ddl command?
What is spid in sql server profiler?
What is tcl in sql server?
What encryption security is available in sql azure?
How can we improve performance by using SQL Server profiler?
How to use linked server?
Differentiate between delete and truncate.
What is difference between table aliases and column aliases? Do they affect performance?
What program is used to store the data source file?
mention different types of relationships in the dbms?
What are rest-style architecture's?
How data can be copied from one table to another table?
How to use column default values in insert statements in ms sql server?
Is sql server is free?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration