查找在同一城市运营的客户

Question

我有客户节点，第二个节点是地址

存在关系客户LOCATED_IN地址

我想获得位于同一城市的所有客户，返回城市，计数和客户名称按计数说明排序

MATCH (c:Customer)-[:LOCATED_IN]->(a:Address)
WITH a.city as city, count(*) as count
WHERE count > 1
RETURN city, count, collect(c.name)
ORDER BY count DESC;

C未定义(第4行，第29列(偏移量: 120)) "RETURN city，count，collect(c.name)“^ Neo.ClientError.Statement.InvalidSyntax

查询工作正常，如果我删除“收集(c.name)”，但嗯，然后我错过了一些信息，我想要得到的…

Answer 1

我认为您需要将c带入WITH子句，如下所示：

MATCH (c:Customer)-[:LOCATED_IN]->(a:Address)
WITH a.city as city, count(*) as count, c
WHERE count > 1
RETURN city, count, collect(c.name)
ORDER BY count DESC;