试试这个：
SELECt id, name, (SELECT COUNT(name) FROM markers im WHERe state like 'OR' GROUP BY name HAVINg im.name=m.name) as countFROM markers m WHERe state like 'OR' GROUP BY name, id
试试这个：
SELECt id, name, (SELECT COUNT(name) FROM markers im WHERe state like 'OR' GROUP BY name HAVINg im.name=m.name) as countFROM markers m WHERe state like 'OR' GROUP BY name, id
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
