how to delete all duplicate records from a table using
subquery?
Answer Posted / lingareddy
by using below sub query delete duplicate all records:
DELETE FROM dept WHERE salary IN (
SELECT salary FROM dept GROUP BY salary HAVING ( COUNT(salary) > 1 ))
here is dept is the table name
salary is the column name
for any doubts about SQL contact with me
Thanks & Regards
Lingareddy.S
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what happened to the global index when I truncate the data in one of the partition?
How to use fetch statement in a loop?
What are data pump export and import modes?
What are the differences between char and varchar2 in oracle?
Where are the settings stored for each instance in oracle?
How to find the duplicate rows count from employees table in oracle?
How to select an oracle system id (sid)?
How do I connect to oracle?
How different is ms access and oracle?
How to write a query with a left outer join in oracle?
How can you merge two tables in oracle?
What is hash cluster in oracle?
How to fetch the row which has the max value for a column?
What is ceil and floor in oracle?
How to manage transaction isolation level?