delete PersonTicketDisplay where id in ( select MAX(PTD.Id) id from PersonTicketDisplay PTD join PersonTicketDisplay PTD2 on PTD.PersonId = PTD2.PersonId and PTD.TicketId = PTD2.TicketId and PTD.Id != PTD2.Id group by PTD.TicketId, PTD.PersonId )