gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

 

Try Distinct clause ......

kasi

• Feb 17th, 2007

 

suppose a table test contains
--------------------------------------
ename                         eno
-------------------------------------
kasi                                   1

kasi                                   1

This duplicate can be removed using rowid with self join

delete * from test where rowid>(select Min(rowid) from test t where t.ename=test.ename);

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Feb 18th, 2007

 

Ok kasi sir by using this query we can only delete the duplicate value or whole data will be deleted....

anonymous

• Sep 8th, 2007

 

Here in this query, the rowid (which is assigned to every row for every row of table ion oracle is used to identify and delete the duplicate rows in the table)as there is no other way of doing the same.

The smallest row id of the row is taken for comparing the other rowids and delete the one greater than the comparision value.

Mital Mehta

• Oct 12th, 2007

 

Kasi , you are right but the syntax is Wrong .
if u write delete *  it will not work .

u have to write like this way

delete from test where rowid>(select Min(rowid) from test t where t.ename=test.ename)

RenukaRajput

 Profile Answers by RenukaRajput Questions by RenukaRajput

• Nov 29th, 2007

 

delete table_name where col_name in(select col_name from table_name group by
col_name having count(*) > 1)