所以我想做一些类似以下sql代码的事情:
select s.id, s.name,s.city
from stuff s
group by s.name having count(where city and name are identical) > 1
要生成以下内容(但忽略只有名称或城市匹配的地方,必须在两列上):
id name city
904834 jim London
904835 jim London
90145 Fred Paris
90132 Fred Paris
90133 Fred Paris