Cypher
Frequently Asked Questions
General
Cypher |
SQL |
---|---|
RETURN | SELECT |
MATCH | FROM...JOIN ON... |
WHERE, ORDER BY, LIMIT, SKIP are the same | |
Automatic grouping | GROUP BY |
Query pipelining with WITH no need for HAVING | HAVING |
Both have support for (user defined) procedure and function calls | |
COLLECT and UNWIND to aggregate and expand lists of data | |
No window functions | |
Subqueries via CALL {} syntax | FROM() |
Data loading with LOAD CSV | |
Batching via CALL {} IN TRANSACTIONS | |
Variable path length pattern syntax | Recursive common table expressions (CTEs) |