这样的事情
select email ,max(receiveddate) as MaxDate from YourTable group by email having count(email) > 1