本文共 2960 字，大约阅读时间需要 9 分钟。
以下是一些针对Cypher数据库中电影和演员关系的查询示例，旨在高效地获取满足特定条件的影视信息。
MATCH (p:Person)-[:ACTED_IN]->(n:Movie) WITH p, count(n) as nCount WHERE nCount > 3 RETURN p, nCount;
MATCH (p:Person)-[:ACTED_IN]->(n:Movie) WITH p, count(n) as nCount WHERE nCount >= 3 RETURN p, nCount;
MATCH (m:Movie)-[:ACTED_IN]->(p:Person) WITH m, count(p) as pCount RETURN m, pCount;
MATCH (m:Movie)-[:ACTED_IN]->(p:Person) WITH m, count(p) as pCount RETURN m, pCount;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount RETURN p, mCount;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount RETURN p, mCount, collect(m.name);
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
MATCH (p:Person)-[:ACTED_IN]->(m:Movie) WITH p, count(m) as mCount, collect(m.name) as names RETURN p, mCount, names;
以上查询可以根据具体需求进行调整，主要用于从Cypher数据库中高效获取电影和演员之间的关系数据。通过合理使用这些查询，可以快速定位出参演次数较多的演员及其所参与的电影项目。
转载地址：http://sfcfk.baihongyu.com/