Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from table in sql server
- 12 Answers
- 23276 Views
- HCL, UHG, I also Faced
- E-Mail Answers
Answer Posted / vineet dhamija
the best approach i came across in simple form too
just create a temporary table with the distinct values and
truncate this table than copy the values back and u r good to go
select distinct * into #temp from urtable
truncate table urtable
insert into urtable select * from #temp
drop table #temp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you think BCNF is better than 2NF & 3NF? Why?
How to create “dependant” parameter “make, model, year”
What is sql sandbox in sql server?
What are the differences between clustered and non-clustered index?
What are the types of containers in ssis?
Explain what is cte (common table expression)?
How do I start and stop sql server?
What is use of except clause? How does it differ from not in clause?
How to provide default values to function parameters?
Explain about builtinadministrator?
How to install sql server 2005 express edition?
Why do we partition data?
how you can deploy an ssrs report?
How to create and drop temp table in sql server?
What is the use of tempdb? What values does it hold?
