ramniwas

• Sep 5th, 2011

 

Code
 

Pavan

• Sep 7th, 2011

 

delete from where rowid in (select max/min(rowid) from group by having count(*)>1)

Art11

 Profile Answers by Art11 

• Sep 19th, 2011

 

Replace select with delete:

Code
 

iftekhar

• Sep 20th, 2011

 

Code
 

Art11

 Profile Answers by Art11 

• Sep 21st, 2011

 

To make my prev. posts readable...

Replace select with delete:

SELECT ename FROM emp1 e WHERE ROWID > (SELECT MIN(rowid) FROM emp1 WHERE ename = e.ename)

Art11

 Profile Answers by Art11 

• Sep 21st, 2011

 

Assuming that ename and job is the same or First and Last name...

SELECT * FROM (SELECT empno, ename, job ,RANK() OVER (PARTITION BY ename, job ORDER BY empno) AS SeqNo FROM emp1) WHERE SeqNo > 1

anonymous

• Sep 27th, 2011

 

Code