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
Do you know nested transaction?
Explain the dirty pages?
What is precedence constraint?
How to download and install microsoft sql server management studio express?
Give the query of getting last two records from the table in SQL SERVER?
What is the use of custom fields in report?
What is rolap and its advantage? : sql server analysis services, ssas
Do you know what is difference between stored procedure and user defined function?
Distinguish between commit and rollback?
What is the difference between Stored Procedures and triggers?
How global temporary tables are represented and its scope?
What is the full meaning of dml?
What are types of subqueries?
Is it important for a database administrator to understand the operating system and file access?
How to scale out a federation by Sql statement?