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
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Can you always create a cache of a report?
How would you go about developing a ssrs report?
Explain transaction server implicit?
What is the syntax for encrypting a column in SQL Server?
How will you optimize a stored procedure optimization?
What are acid properties of transaction?
What are the differences between stored procedure and view in sql server?
What does set rowcount do?
what's the maximum size of a row? : Sql server database administration
What is the use of toad or sqldbx.?
Explain how to use linked server?
How to execute stored procedure and set temp table in sql server?
Tell me what is fill factor?
What is the maximum number of index per table?