How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
Answer Posted / arun kumar k s
drop table #TEMP select distinct * into #TEMP from
TABLE_NAME delete from TABLE_NAME insert into TABLE_NAME
select * from #TEMP
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Does a server store data?
Can a cursor be updated? If yes, how you can protect which columns are updated?
List out a number of the wants to setup a SQL Server failover cluster?
Is the order of columns in the set clause important in ms sql server?
Can we delete data from a view?
What is the user of Primary key?
Describe in brief system database.
What are the advantages of paper records?
How will you go about resolving deadlocks?
Explain ms sql server reporting services vs crystal reports?
How dts is used to extract, transform and consolidate data?
How many types of database relationship in sql server?
1 01 101 01010
How to find related tables in sql server?
How to insert multiple rows with a subquery?