您可以尝试类似
SELECt PersonName, AddressFROM ( SELECt *, (SELECT COUNT(1) FROM addresses WHERe Address = a.Address AND PersonName < a.PersonName) CountLess FROM addresses a ) subWHERe sub.CountLess <= 2
您可以尝试类似
SELECt PersonName, AddressFROM ( SELECt *, (SELECT COUNT(1) FROM addresses WHERe Address = a.Address AND PersonName < a.PersonName) CountLess FROM addresses a ) subWHERe sub.CountLess <= 2
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
