OraFAQ Forum: Server Administration » Re: Delete Duplicate Rows

Home » RDBMS Server » Server Administration » Re: Delete Duplicate Rows

Wed, 14 February 2001 22:22

geetha
Messages: 20
Registered: August 2000

Junior Member

delete * from emp a where not a.rowid = (select max(b.rowid) from emp b where b.empno=a.empno);

this shd satisfy ur query...

Geetha

Previous Topic:	Constraint question.
Next Topic:	use of sql

Goto Forum:

]

Current Time: Mon Dec 23 01:51:41 CST 2024