A further question, I am now using the following piece of code to report a count where the code is I

SELECT count(*)

FROM (SELECT ref_id, cus_id, code, amt,

ROW_NUMBER() OVER(PARTITION BY...

Many thanks, works a treat (I'm not very familiar with OVER(PARTITION ...)