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
How to create a purchase order without a requisition?
What is a flexfield? List out its types.
Can you differentiate between mediator and osb?
What is the concept of soa governance?
In hierarchical structure of a database? we have write query from where we should start?
Is soa a part of oracle fusion middleware?
what is pay run id ?
Which oracle apps version you are very confident in?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
how can i print random rows in plsql table
please send me forms, xml pulisher questions,answers
Can you define an erp system?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What do you understand by soa?