If you found two duplicated item_no's why did four rows get deleted? Wouldn't you want to delete just one of the duplicates so that one unique row would remain?

I must be missing something. Thanks for your explanation in advance.

Richard