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 |
How is choreography different from orchestration?
Explain the multi-organization structure.
What is invoice?
Can u define operating units inplace of inventory?
In hierarchical structure of a database? we have write query from where we should start?
which parameters passed in report in oracle developer how to pass
How to send the e-mail notification in XML Pub Report?
Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.
What is the package?
Steps for DFF registration
we have 10 records. It's occured error in 6th record how can u find and how to rectify that?
what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference