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

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,


how will u do documentation

2 Answers  


why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,


how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,


How will U link GL with OU in Multi-org environment.

3 Answers   Convergys,


After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,


In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,


any one can expalin report registration steps?

6 Answers   Infosys,


what is meant by bind parameter?

2 Answers   Satyam,


tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,


How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,


what are the different transaction clauses in AR?

0 Answers   BirlaSoft,


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)