Neo4j 简明教程
Neo4j - Skip Clause
SKIP 子句用于定义从哪一行开始包含输出中的行。
The SKIP clause is used to define from which row to start including the rows in the output.
Example
在继续示例之前，请像下面一样创建 5 个节点。
Before proceeding with the example, 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"})以下是返回数据库中跳过前 3 个节点的所有节点的 Cypher 查询示例。
Following is a sample Cypher Query which returns all the nodes in 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 query, carry out the following steps −
Step 1 - 打开 Neo4j Desktop App 并启动 Neo4j Server。使用 URL http://localhost:7474/ 打开 Neo4j 的内置浏览器应用，如下面的屏幕截图所示。
Step 1 − Open the Neo4j desktop App and start the Neo4j Server. Open the built-in browser app of Neo4j using the URL http://localhost:7474/ as shown in the following screenshot.
Step 2 - 在美元提示符中复制并粘贴所需的查询，并按播放按钮（执行查询）突出显示在下面的屏幕截图中。
Step 2 − Copy and paste the desired query in the dollar prompt and press the play button (to execute the query) highlighted in the following screenshot.
Skip Using Expression
你可以使用表达式跳过某个结果的记录。
You can skip the records of a result using an expression.
Example
以下是使用 SKIP 子句和表达式的 Cypher 查询示例。
Following is a sample Cypher Query which uses the SKIP clause with an expression.
MATCH (n)
RETURN n.name, n.runs
ORDER BY n.runs DESC
SKIP toInt (2*rand())+ 1Step 1 - 打开 Neo4j Desktop App 并启动 Neo4j Server。使用 URL http://localhost:7474/ 打开 Neo4j 的内置浏览器应用，如下面的屏幕截图所示。
Step 1 − Open the Neo4j desktop App and start the Neo4j Server. Open the built-in browser app of Neo4j using the URL http://localhost:7474/ as shown in the following screenshot.
Step 2 - 在美元提示符中复制并粘贴所需的查询，并按播放按钮（执行查询）突出显示在下面的屏幕截图中。
Step 2 − Copy and paste the desired query in the dollar prompt and press the play button (to execute the query) highlighted in the following screenshot.
