Re: DELETE rows?
Shah,
If you still have the original data set, you can run just the select portion of that query against it. Those are the rows that will be deleted by the full query.
With that query, even if you had some rows with triplicates (or more), only the row with the max number would be deleted. The only way for multiple rows with the same id to be deleted would be to have multiple rows with matching id and number AND that number be the max number for that id.
HTH,
Chad
Subject
Written By
Posted
Re: DELETE rows?
June 16, 2010 07:44AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.