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
Can foreign key be deleted?
What are the properties and different types of sub-queries?
What extended events?
What is attribute hierarchy? : sql server analysis services, ssas
Can a database be shrunk with users active?
What are the advantages of sql azure?
What do you mean by an execution plan? Why is it used?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What do you understand by mirroring?
Which is the latest version of sql server and when it is released?
What are drillthrough reports?
How does stuff differ from the replace function?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is lock escalation and what is its purpose?
What is partitioned view?