How To delete duplicate record from a particular table?
- 12 Answers
- 22812 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
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 is default port number for sql server 2000?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are date and time data types in ms sql server?
What is user defined stored procedures?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is transact-sql language?
How do I partition a table in sql server?
Which are the third-party tools used in sql server and why would you use them?
Explain how would you store your query in an SSRS report or a Database server?
Tell me about joins in database system and explain each in detail.
what's the difference between a primary key and a unique key? : Sql server database administration
What are .mdf files?
Describe triggers features and limitations?
What is ems sql management studio? : sql server management studio
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
