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
How to write numeric literals in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Explain what are the different type of segments?
How can Oracle users be audited?
What is oracle database client?
Please explain compound trigger in oracle?
How to estimate disk space needed for an export job?
What is the difference between a user and a schema in oracle?
Explain how you would restore a database using RMAN to Point in Time?
What is ceil and floor in oracle?
When system tablespace is created?
How to use group functions in the select clause using oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to test null values?
Difference between the “verify” and “feedback” command?