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 |
Oracle E-Business suite?
Can function be overload?
When loading data from staging table to interface table , how to reload the invalid record once again ?
how will you refer a report column (data column,formula,summery,placeholderr)?
What repots or concurrent program run to transfer data from Inventory to GL.
What is procedure?
What is Value Set?
What do you understand by soa and what are the benefits of using this architecture?
What is the difference between base table and multi-org table?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
what is mutating table and mutating error and how to solve that?