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 are documents and test cases u followed.
what is the difference between oracle 8i and 9i?
cursor 1 and cursor 2 are there did you open both the cursors at a time or not?
in GL module specifing org_id or not?
What are the Import Programs We need to run after creating Interface table for all modules
Is it possible calling from one report to another? if possible means tell me ?
3 Answers Intelligroup, Satyam,
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
How do u customize the Reports?
In oracle application how do you debug or trace errors?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
What is SRW Package? (Sql Report Writer)
Explain the multi-organization structure.