Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / bharath
1.SELECT ROWID FROM TABLE T1
WHERE ROWID NOT IN (SELECT MIN(ROWID)
FROM TABLE T2 WHERE T1.KEY=T2.KEY);
THIS QUERY IS USEFUL WHEN WE HAVE A KEY VAL.
2.
i.CREATE TABLE NEW AS SELECT DISTINCT * FROM OLD;
ii.DROP TABLE OLD;
iii.RENAME NEW TO ORIGINAL;
THIS IS WHEN WE APPLY TO DELETE DUPLICATE ROWS..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can we get profile values in report without using user exists is it possible how?
Can you explain the difference between architecture followed in 10g & 11g?
What are file in oracle.
In sequence i want to 11 and 15th values how we will write?
What do you understand by concurrent programs?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
testing tools?
tell me the scenarios of the independent in reports
Do you know what are user profiles in apps. Any examples you can give?
What is instead of trigger in where we will use?
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
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
Tell me where we find the status of order information?
Tell me how to find the custom directory in front end?
how to print multi lay outs,muti currency,muti language in xml publisher