Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 77226 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / pnr kiran
DELETE FROM TABLE E
WHERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Do you know where we can check the status of po?
In sequence i want to 11 and 15th values how we will write?
tell me the scenarios of the independent in reports
what is global tempory table?
How to create a purchase order without a requisition?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Is soa a part of oracle fusion middleware?
what are the prerequisites for costing transactions?
What is oracle soa suite and what are its different components?
What are the benefits of using soa architecture?
Can we create tables in apps schema?
In oracle application how do you debug or trace errors?
q)what are the validations in sql*loader
What do you understand by soa?
