在neo4j中获取字段值和总和之间的差异 [英] get difference between field values and sum in neo4j

问题描述

如何使用neo4j查询获得r.rating_val和rw.rating_val这两个字段之间的差异以及这些字段的总和?我真的很感谢您的帮助.

How can I get difference between 2 fields: r.rating_val and rw.rating_val and sum of these fields using neo4j query?I really appreciate any help.

MATCH (a:user{id:"1"})-[r:`rating`]->(b),
 (w:user{id:"3"})-[rw:`rating`]->(b)
RETURN DISTINCT b,r.rating_val ,rw.rating_val

推荐答案

只需在return子句中减去/添加它们

Just subtract/add them in the return clause

MATCH (a:user{id:"1"})-[r:`rating`]->(b),
 (w:user{id:"3"})-[rw:`rating`]->(b)
RETURN DISTINCT b,
r.rating_val-rw.rating_val as difference,
r.rating_val+rw.rating_val as sum

这篇关于在neo4j中获取字段值和总和之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！