Neil,

You need both columns in the result and the group by.

select mainkey, no_in_row, count(*) as cnt ;
   from ...
   group by mainkey, no_in_row ;
   having cnt > 1

>This only gives me the count of how many records for each mainkey?