How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
Answer Posted / cp
DELETE FROM emp WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM
emp GROUP BY empno)
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
How can i Relate Tables in SSIS
Can we use having clause without group by?
what is datawarehouse?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is the name of the Database which IBM mainframe uses?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is collation?
How to delete an existing row with delete statements in ms sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How can we delete Duplicate row in table?
Which is better statement or preparedstatement?
Explain boyce and codd normal form(bcnf)?
How to turn off warning messages during php execution?
Difference between drill down and drill through report.
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?