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
sql查询同一个表中两条记录,一个字段一样,另一个不一样
最新推荐文章于 2024-04-24 17:08:01 发布