suman

• Jan 16th, 2007

 

We can delete the redundant data using 'count(Coloumn) >1'  ,

kajamaideen

• Jan 19th, 2007

 

delete from emp where rowid not in(select max(rowid) from emp group by deptno);

anandprasad

 Profile Answers by anandprasad 

• Jan 31st, 2007

 

select * from emp e1 where rowid > (select min(rowid) from emp e2 where e1.empno = e2.empno)

madhuk17

 Profile Answers by madhuk17 Questions by madhuk17

• Feb 17th, 2007

 

delete from emp a where rowid not in
(select min(rowid) from emp b where a.empno=b.empno);

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Mar 27th, 2007

 

Using Self join like.

Delete from emp where id in (select id from emp a,emp b
                                               where a.id=b.id and a.rowid<>b.rowid
                                               );