SELECT NARRATION, VCH_DATE, COMP_CODE, VCH_AMOUNT, COUNT(1) FROM ACCOUNTS.ACCOUNTS_VOUCHER_MAST WHERE AUTO_TRANS = 'T' AND STATUS <> 'C' AND VCH_DATE BETWEEN '01-APR-2010' AND '31-MAR-2011' AND VCH_NO IN (SELECT VCH_NO FROM ACCOUNTS.ACCOUNTS_VOUCHER_DTLS WHERE ACC_CODE = '0000000000182') HAVING COUNT(1) > 1 GROUP BY NARRATION, VCH_DATE, COMP_CODE, VCH_AMOUNT