Query to Find duplicate Records

   select A, B, C,

       count(*)

from   Mytable where  'My Where clause'

group  by A,B,C,

having count(*) > 1;