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
What are the drawbacks of reporting in ssrs?
What is join and name different type of joins?
How do you check sql server is up and running?
What are Row versions of DataRow?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How to recompile stored procedure at run time?
How to insert multiple rows with a subquery?
What is optimization and its types?
What is difference between equi join and inner join?
Define model database?
Explain full-text indexing?
In what sequence sql statement is processed?
Is it ok to shrink transaction log?
What is a field name?
You want to use a perspective in an mdx query. How do you select the perspective?