select TransactionID, count(*) 
  from Transaction 
 group by TransactionID 
having count(*) > 1