NEO4J中的UNION

和传统数据库中SQL的UNION关键字用法一样，合并两个查询集、UNION ALL 含重复结果，UNION不含重复结果；

查找所有的人员名称和电影名称，合并后输出

MATCH (n:Person)
RETURN n.name AS name,'Person' as p
UNION ALL 
MATCH (n:Movie)
RETURN n.title AS name,'Movie' as p

 

如果是SQL的话，写法为

SELECT p.name as name,'Person' as p FROM Person p
 UNION ALL
SELECT m.title as name,'Movie' as p FROM Movie m