Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / swati
DELETE FROM <table_name> T1
WHERE T1.ROWID > (SELECT MIN(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
----------------------------
DELETE FROM <table_name> T1
WHERE T1.ROWID < (SELECT MAX(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
Do you know where we can check the status of po?
In oracle application how do you debug or trace errors?
What are the different components of soa suite?
What are do's and dont's of Interface?
what is the differences between internal requisition and internal sales order?
What is sca and how is it useful?
is it possible to run the interface without using oracle apps?
please send me forms, xml pulisher questions,answers
what is the difference between request group and request security in oracle apps?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How many schemas we have? how many you have used?
how do you describe O2C along with tables
Can you explain the difference between architecture followed in 10g & 11g?
tell my any difficult situtation you solved in your experience in your company?
Can you define an erp system?