Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 74517 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / venki_discussions
delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
In support project one ticket alloted which steps follows manualy tell me ?
What does appl_top directory contain?
what are the prerequisites for costing transactions?
What is a flexfield? List out its types.
What is count(*) from po_vendors(any table)?
In hierarchical structure of a database? we have write query from where we should start?
Do you know what are user profiles in apps. Any examples you can give?
Explain what are the tables of auto invoice?
What are the different components you should consider while defining a responsibility in oracle apps?
What is sca and how is it useful?
Can you define an erp system?
What are the Standard Reports and Forms in HRMS?
In oracle application how do you debug or trace errors?
How can you achieve loose coupling in soa framework?
What do you understand by soa?
