Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from table in sql server
- 12 Answers
- 22701 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
Explain user defined functions?
How to change the system date and time from SQL Plus Terminal ?
What are different types of raid configurations? : SQL Server Architecture
Can you name a few encryption mechanisms in sql server?
What are the limitations in ssrs on sql server express edition?
What is difference between table aliases and column aliases? Do they affect performance?
What is the difference between Clustered and Non-Clustered Index?
what stored procedure would you use to view lock information? : Sql server administration
How to backup SQL Server Reporting Services ?
How to retrieve field values using mssql_result()?
How to add code to the existing article (using improve article)?
What is the difference between function and stored procedure in sql server?
What is relationship? What number of sorts of relationship are there?
What is the purpose of floor function?
What is the stored procedure?
