SELECT a.unique_id 
  FROM my_table as a, my_table as b 
 WHERE a.field1 = b.field1
   and a.field2 = b.field2
   and a.field3 = b.field3
   and a.unique_id != b.unique_id