neo4j 密码嵌套查询

bweufnob 于 12个月前发布在其他

关注(0)|答案(2)|浏览(172)

试图在cypher sql中构建嵌套查询来查找grossale，distinctcustomer和salesreach的销售额，并且无法将列1的值作为输入传递给另一列-任何帮助都将不胜感激。
在这里

MATCH (n:Commercial)
WITH (n) AS grosssales, count(n) AS distinctcustomer, 
  n.customer_id AS customer, ### grouping by customer_id ###
  grosssale / distinctcustomer AS salesreach
RETURN grossale, distinctcustomer, salesreach, customer_id

字符串
尝试了WITH子句，但没有喜悦，将感谢任何帮助，在纠正密码语法。

neo4j

来源：https://stackoverflow.com/questions/77576343/cypher-nested-query

2条答案

按热度按时间

vof42yt11#

MATCH (n:Commercial) 
WITH count(n) AS grosssales 
MATCH (c:Commercial) 
WITH grosssales,count(c) AS distinctcustomer, c.customer_id AS customer, tofloat(grosssales/count(c)) AS salesreach 
RETURN imp AS grosssales, distinctcustomer, customer, salesreach

字符串

赞(0）回复(0）举报 12个月前

nr9pn0ug2#

可以使用新的COUNT subquery（neo4j 5.0+中）来计算Commercial节点的总数，从而简化查询。尽管COUNT()是一个聚合函数，但customer子查询不是--因此它不受customer分组键的影响。

MATCH (c:Commercial) 
WITH COUNT{ (:Commercial) } AS grosssales, COUNT(c) AS distinctcustomer, c.customer_id AS customer
RETURN grosssales, distinctcustomer, customer, TOFLOAT(grosssales/distinctcustomer) AS salesreach

字符串

赞(0）回复(0）举报 12个月前

我来回答

neo4j 密码嵌套查询

2条答案

相关问题

热门标签

最新问答