SQL：在单个结果行中进行组计数

试试这个：

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