Example

SELECT COUNT(), PARENT_KEY, SEQ, PARENT_ATTRIB, ACTEXEPK FROM CSM.NS_BPPACTIVITYEXE GROUP BY PARENT_KEY, SEQ, PARENT_ATTRIB, ACTEXEPK HAVING COUNT()>1;

Use those column in Select and Group by may have duplicate records