Neo4j 聚合函数 [英] Neo4j aggregate function

问题描述

我正在尝试使用 SUM 函数并将其结果存储为关系的新属性.但它不起作用.我使用的查询是:

I am trying to use the SUM function and store the result of it as a new property of the relationship. But it is not working. The query I used is :

MATCH (a:Employee)-[r:CorporateMessage]->(b)
WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001]
SET r.Internalsum = SUM(r.Count)

我得到的错误是:

在此上下文中聚合函数 sum(...) 的使用无效(第 1 行，第 124 列(偏移量:123))MATCH (a:Employee)-[r:CorporateMessage]->(b)WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001] SET r.Internalsum = SUM(r.Count)"

Invalid use of aggregating function sum(...) in this context (line 1, column 124 (offset: 123)) "MATCH (a:Employee)-[r:CorporateMessage]->(b)WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001] SET r.Internalsum = SUM(r.Count)"

请解释我做错了什么.

推荐答案

试试看:

MATCH (a:Employee)-[r:CorporateMessage]->(b)
WHERE a.Eid = 6001 AND b.Eid IN [6002,6003,6004,6005,5001]
WITH r, SUM(r.count) as count
SET r.Internalsum = count

始终将聚合函数放在中WITH 或 RETURN.

这篇关于Neo4j 聚合函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！