+3 votes
in Databases by (51.8k points)
I want to skip first 5 rows returned by the Cypher query and select the remaining rows. What is the syntax for it in Cypher?

1 Answer

+1 vote
by (281k points)
selected by
 
Best answer

You can use SKIP in your Cypher query to trim 'k' results from the top. The order will not be guaranteed if you do not use ORDER BY clause.

Here is an example query:

MATCH (n:movies)
RETURN n.title
ORDER BY n.title
SKIP 5

The above query sorts the title in ascending order and skips the top 5 rows.

Related questions


...