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
Sql server reporting services vs. Crystal reports.
What are dml triggers and types of dml triggers?
What is user defined stored procedures?
How to rename databases in ms sql server?
what are the different types of SSRS reports?
What is implicit cursors?
Define self join?
Explain transaction server isolation?
Explain the truncate command? : SQL Server Architecture
What is an index in sql?
What are the advantages of using stored procedures?
why would you use sql agent? : Sql server database administration
What is a partitioned view?
What can be used instead of trigger?
Can we delete data from a view?