我有一张联系表。该表包含mobile_phone列和home_phone列。我想获取所有重复的联系人，其中重复是两个共享一个电话号码的联系人。如果联系人A的mobile_phone与联系人B的home_phone匹配，则这也是重复项。这是应该匹配的三个联系人的示例。& y- _/ S# s3 R) s3 M- ] D
contact_id|mobile_phone|home_phone|other columns such as email.......|...3 v. m" q+ f; L0 t' b+ T2 T0 f
-------------------------------------------------------------------------) q$ y) ?, K; t
111 |9748777777 |1112312312|..................................|... , ~7 ?( I3 o1 s' H3 y8 G, R112 |1112312312 |null |..................................|...: E7 ^/ d, u. Q* F
113 |9748777777 |0001112222|..................................|...' Y3 m, i B9 H
这是一个查询，查找重复项，但不跨字段。+ D: f0 d2 W4 \$ P3 B
select mobile_phone from contacts group by mobile_phone HAVING count(*) > 1 order by mobile_phone! C6 i9 T5 S; c# _2 \3 l
技术问答
500 人阅读
|
0 人回复
|
2023-09-11
