Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 71443 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
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
what are the prerequisites for costing transactions?
What is sca and how is it useful?
where to define interorganization transaction charges and what are the different options?
testing tools?
what is the difference between request group and request security in oracle apps?
is it possible to run the interface without using oracle apps?
What is instead of trigger in where we will use?
What do you understand by concurrent programs?
How to create a purchase order without a requisition?
What do you understand by soa?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How can a process be deployed in soa?
