Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answers were Sorted based on User's Feedback
Answer / koti
Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .
| Is This Answer Correct ? | 15 Yes | 16 No |
Answer / 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 |
Answer / satyan
simple query
step 1
select rowid,column1,column2,column3 from table name where
condition;
step 2
delete from table name where rowid = '........'
| Is This Answer Correct ? | 4 Yes | 11 No |
Answer / ganesh
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
| Is This Answer Correct ? | 14 Yes | 24 No |
What is INBOUND and OUT BOUND? (Different types of interfaces)
17 Answers Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,
The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.
How to attach the multiple templates in XML Pub Report?
Can u define DFF with in the DFF,How?
what is the difference between character mode,bitmap mode
2 Answers IBM, Sierra Atlantica,
Oder of firing triggers in form
How do u identity its name of report?
Can u suggest me the best institute for Oracle apps Technical in Hyderabad?
in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me
Is SOB is attached with Business grp ?
how many sections are there in report?
How many typres of Purchase order and what are those.