The SKIP clause is used to define from which row to begin together with the rows in the output.
Example
Before proceeding with the instance, create 5 nodes as shown below.
CREATE(Dhawan:player{name:"shikar Dhawan", YOB: 1985, runs:363, country: "India"})
CREATE(Jonathan:player{name:"Jonathan Trott", YOB:1981, runs:229, country:"South Africa"})
CREATE(Sangakkara:player{name:"Kumar Sangakkara", YOB:1977, runs:222, country:"Srilanka"})
CREATE(Rohit:player{name:"Rohit Sharma", YOB: 1987, runs:177, country:"India"})
CREATE(Virat:player{name:"Virat Kohli", YOB: 1988, runs:176, country:"India"})
Following is a pattern Cypher Query which returns all the nodes within the database skipping the first 3 nodes.
MATCH (n)
RETURN n.name, n.runs
ORDER BY n.runs DESC
SKIP 3
To execute the above question, perform the subsequent steps −
Step 1 − Open the Neo4j desktop App and begin the Neo4j Server. Open the integrated browser app of Neo4j using the URL http://localhost:7474/ as shown within the following screenshot.
Step 2 − Copy and paste the preferred query inside the greenback set off and press the play button (to execute the question) highlighted inside the following screenshot.
Result
On executing, you may get the subsequent end result.
Skip Using Expression
You can bypass the information of a result the usage of an expression.
Example
Following is a sample Cypher Query which makes use of the SKIP clause with an expression.
MATCH (n)
RETURN n.name, n.runs
ORDER BY n.runs DESC
SKIP toInt (2*rand())+ 1
Step 1 − Open the Neo4j desktop App and start the Neo4j Server. Open the integrated browser app of Neo4j using the URL http://localhost:7474/ as shown in the following screenshot.
Step 2 − Copy and paste the desired question within the dollar activate and press the play button (to execute the question) highlighted inside the following screenshot.
Result
On executing, you may get the following result.