sql查询同一个表中两条记录，一个字段一样，另一个不一样

SELECT * FROM t_member_identity t1,( SELECT max( id ), one_id, member_id FROM `t_member_identity` GROUP BY member_id HAVING count(*) > 1 ) t2 
WHERE
    t1.member_id = t2.member_id 
    AND t1.one_id <> t2.one_id