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 the error you will get if field is referenced in wrong repeating frame?
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
Which oracle apps version you are very confident in?
in one report using two layout models.if yes how to do
Can we create tables in apps schema?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
in one report using two layout models.if yes how to do
types of invoices?
7 Answers BelAir Store, Convergys, Wings Biotech,
where the accounting related data is stored ? all type of accounting related data costing etc...
what is the standard program for blanket po to process data from interface table to bace table
in interface and conversion if 10 records are error out we can't load the records?if >10 we have to insert,if we not insert we need to gernerate error how u can achieve?
What is template?