Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / madhuapps
delete from t1 tl
where tl.rowid >
( select min(tl2.rowID) from t1 tl2
where tl.col1 = tl2.col1
and tl.col2 = tl2.col2)
| Is This Answer Correct ? | 25 Yes | 31 No |
Post New Answer View All Answers
What does appl_top directory contain?
tell me the scenarios of the independent in reports
What do you understand by a set of books?
tell me the scenarios of the independent in reports
how can develope the po variance and po summary report? with tables mandatory columns and query please?
In oracle application how do you debug or trace errors?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What are the Standard Reports and Forms in HRMS?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
Can you define an erp system?
Tell me where we find the status of order information?
please send me forms, xml pulisher questions,answers
Tell me how to find the custom directory in front end?
Do you know what is applysys in oracle application database schema, what is apps?
What are the different components of soa suite?