关键是重写此查询，以便可以将其用作子查询。
SELECt firstname, lastname, list.address FROM list INNER JOIN (SELECt address FROM list GROUP BY address HAVINg COUNT(id) > 1) dupON list.address = dup.address;
关键是重写此查询，以便可以将其用作子查询。
SELECt firstname, lastname, list.address FROM list INNER JOIN (SELECt address FROM list GROUP BY address HAVINg COUNT(id) > 1) dupON list.address = dup.address;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
