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

Answer / veera

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

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>)

Answer / arjun

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






Arjun

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.. :)

Answer / venki_discussions

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

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...

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

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);

Answer / sushmitha

This link provides different methods of removing duplicate
rows from table

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

What multi org tables . example - difference between app table non all table . Po_header and po_headers_all

1 Answers   IBM,

when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,

In interface how u find errors and how to solve. How to fix it?

3 Answers  

difference b/w procedures&functions

2 Answers   Oracle, TCS,

Which module is not in multiorg

6 Answers   HCL, Wipro,

how to make a parameter optional in the query?

2 Answers   Wipro,

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

we have 4 managers if one person logon the system automatically displays his siganature and name how?

1 Answers   BirlaSoft,

What are file in oracle.

0 Answers   BirlaSoft, IBM,

how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

Tell me some thing about SQL-LOADER.

2 Answers   IBM,