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 |
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,
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232
How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?
how to initialize applications?
what is organization id
Form development process?
What is the difference between BPA AND Contract.
what are the pl/sql tables
What are the Import Programs We need to run after creating Interface table for all modules
what are the profiles