How To delete duplicate record from a particular table?
Answer Posted / manoj
DELETE FROM table_name a
WHERE ROWID >(SELECT min(ROWID)
FROM table_name b
WHERE a.col_1=b.col_1 )
Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What type of Index will get created after executing the above statement?
How can you insert values in multiple rows using one Insert statement?
What is query processing?
What stored procedure can you use to display the current processes?
Explain filtered indexes?
What is code near application topology?
What is a fan-out query in SQL Azure?
What is the maximum size of sql server database?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How is table type constraint applied to a table?
What is constraints and its types?
How to defragment indexes with alter index ... Reorganize?
When do you think a developer should use sql server-based cursors?
What is format parameter in ssrs?
What is standby servers? Explain types of standby servers.