Write an SQL Query to
Delete Duplicate records from a table using ROWID.

Answers were Sorted based on User's Feedback



Write an SQL Query to Delete Duplicate records from a table using ROWID...

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

Write an SQL Query to Delete Duplicate records from a table using ROWID...

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

Write an SQL Query to Delete Duplicate records from a table using ROWID...

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

Write an SQL Query to Delete Duplicate records from a table using ROWID...

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

Post New Answer

More Oracle Apps Technical Interview Questions

How is choreography different from orchestration?

0 Answers  


Explain the multi-organization structure.

1 Answers   Accenture,


What is invoice?

3 Answers   Murugappa Group,


Can u define operating units inplace of inventory?

2 Answers  


In hierarchical structure of a database? we have write query from where we should start?

0 Answers   IBM,






which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,


How to send the e-mail notification in XML Pub Report?

2 Answers   Accenture, Oracle,


Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  


What is the package?

2 Answers  


Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,


we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers  


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

4 Answers   IBM,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)