Ratna

• Oct 10th, 2006

 

delete from <table_name> where rowid not in (select min(rowid) from <table_name> group by col1,col2....)

mamathi

• Oct 11th, 2006

 

hi try this it will workdelete emp where name in('anand','jack','yokesh');where in the employee table all are having the same sal.try out

vinoth

• Oct 11th, 2006

 

hi, This will help u i think therw the correlated subquery.... delete from as where rowid not in (select min(rowid) from as where .=.

Pawan Ahuja

• Dec 3rd, 2006

 

Delete from <table_name> where rowid not in (select min(rowid) from <table_name> group by col1,col2....)

Regards

Pawan Ahuja

Sujata Bisoi

• Mar 8th, 2007

 

 i think it will perfectly work:-
    


       delete empname from emp A where  rowid > (select min(rowid) from emp B where A.ename = B.ename);