Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 / rajesh

Delete from table_name where ROWID not in ( select
max(rowid) from table group by duplicate_values_field_name);

Regards
Rajesh...


If any queries..then fwd ...baburajeshd@gmail.com

Is This Answer Correct ?    91 Yes 39 No

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

Answer / veera

delete from tablename where rowid not in(select min(rowid)
from table name group by duplicate record col)

Is This Answer Correct ?    37 Yes 21 No

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

Answer / swati

DELETE FROM <table_name> T1
WHERE T1.ROWID > (SELECT MIN(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)

----------------------------

DELETE FROM <table_name> T1
WHERE T1.ROWID < (SELECT MAX(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)

Is This Answer Correct ?    19 Yes 5 No

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

Answer / arjun

delete from employ where rowid not in(select min(rowid) from
employ group by id,ename,age);






Arjun

Is This Answer Correct ?    17 Yes 7 No

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

Answer / amit bhatnagar

Swati is cool. buth her queries are correct. you can either
take rowid >with subquery fetching minimum (rowid) else
Rowid < with subquery fething maximum (row id)

DELETE FROM <table_name> T1
WHERE T1.ROWID > (SELECT MIN(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)

----------------------------

DELETE FROM <table_name> T1
WHERE T1.ROWID < (SELECT MAX(T2.ROWID)
FROM <table_name> T2
WHERE T2.<common column name> = T1.<common
column name>)
Good job Swati.. :)

Is This Answer Correct ?    15 Yes 6 No

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

Answer / venki_discussions

delete from table (table name.a) where
rowid not in(select min(rowid) from (table name.b)
group by (column name);

Is This Answer Correct ?    8 Yes 1 No

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

Answer / koti

delete from emk tl
where tl.rowid >
( select min(tl2.rowID) from emk tl2
where tl.empno = tl2.empno
and tl.ename = tl2.ename)
Madhuapps,is alsow right...

Is This Answer Correct ?    16 Yes 10 No

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

Answer / samad

delete from emp a where rowid >(select min(rowid) from emp
b where a.rowid = b.rowid);
2. DELETE FROM EMP A
WHERE ROWID > ( SELECT min(ROWID) FROM EMP B WHERE
A.ROWID = B.ROWID)

cheers
samad

Is This Answer Correct ?    21 Yes 18 No

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

Answer / pnr kiran

DELETE FROM TABLE E
WHERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);

Is This Answer Correct ?    4 Yes 1 No

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

Answer / sushmitha

This link provides different methods of removing duplicate
rows from table

http://www.besttechtools.com/SQLArticles.aspx?
ID=DeleteDuplicate

Is This Answer Correct ?    4 Yes 1 No

Post New Answer



More Oracle Apps Technical Interview Questions

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,


We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,


what is fiscalcalendar?

3 Answers   CTS,


what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,


link between po and ap modules

5 Answers   ERP Solutions,






how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  


why do we go for oracle apps technical other than sap and other packages?

2 Answers  


Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,


what are the functions you are used in utl_file at the time of transferring the data?

2 Answers   Oracle,


Can you differentiate between mediator and osb?

0 Answers  


Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,


In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • 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)