Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate rows from a table in SQL Server ??
- 3 Answers
- 7399 Views
- I also Faced
- E-Mail Answers
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
What is ddl command?
What are indexes in sql?
Do you know what is rank function?
Which is the latest version of sql server and when it is released?
How can you check the level of fragmentation on a table?
What are the differences between union, intersect, and minus operators?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are the advantages of sql azure?
What is inline variable assignment?
Explain what is the difference between a local and a global temporary table?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is the definition for sql server 2000?
Does partitioning ssd reduce performance?
Explain difference between cross join and full outer join?
What is the difference between mysql and sql server?
