Select only those records that have different/multiple values for a particular column
You could do something like:

select distinct x.id, x.lastname, x.firstname, x.email
from t as x
join (
    select id
    from t
    group by id
    having count(distinct email) &gt; 1
) as y
    on x.id = y.Id