For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I want to query to find sum of duplicate records in below query
SELECT F_PRODUCT,F_FORMAT,F_SUBFORMAT,F_LANGUAGE, COUNT(*)
FROM T_DOC_ARCHIVE
GROUP BY F_PRODUCT,F_FORMAT,F_SUBFORMAT,F_LANGUAGE
HAVING COUNT(*) > 1