How To delete duplicate record from a particular table?
Answer Posted / sudhagar
Delete from (select * from <TABLE_NAME> where rowid not in
(select min(rowid) from <TABLE_NAME> group by c1,c2...))
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Explain Geometry datatype in sql server 2008 with example
What are binary string data types in ms sql server?
How to create a user name in a database?
List few advantages of stored procedure.
What is bookmark link in ssrs?
What is data compression? : sql server database administration
how to trace the traffic hitting a sql server? : Sql server database administration
What is difference between global temporary tables and local temporary tables?
What do you understand by the denormalisation?
What is the use of custom fields in report?
Is there any difference between the primary key and unique key?
explain extended properties
what are the different types of replication you can set up in sql server? : Sql server database administration
What is code near application topology?
What is isolation levels?