dBforums - View Single Post - oracle query required

#3 (permalink)

08-30-10, 17:51

shammat

Registered User

Join Date: Nov 2003

Posts: 2,407

Try this:

Code:

UPDATE abc
SET h = 'I' 
WHERE a IN (SELECT MIN(a) 
            FROM abc 
            GROUP BY C 
            HAVING COUNT(*) > 1)