Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / ravi kant yadav
Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);
Regards
ravi
| Is This Answer Correct ? | 2 Yes | 0 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 a process be deployed in soa?
What is sca and how is it useful?
Do you know what are user profiles in apps. Any examples you can give?
Which oracle apps version you are very confident in?
tell me the scenarios of the independent in reports
testing tools?
Can you explain the difference between architecture followed in 10g & 11g?
where to define interorganization transaction charges and what are the different options?
Can you define an erp system?
In sequence i want to 11 and 15th values how we will write?
q)what are the validations in sql*loader
Is soa a part of oracle fusion middleware?
List the types of flexfield?
Do you know where we can check the status of po?