Neo4j CQL - RETURN Clause



Neo4j CQL RETURN clause is used -

  • To retrieve some properties of a Node
  • To retrieve all properties of a Node
  • To retrieve some properties of Nodes and associated Relationships
  • To retrieve all properties of Nodes and associated relationships

RETURN command syntax:

RETURN 
   <node-name>.<property1-name>,
   ........
   <node-name>.<propertyn-name>

Syntax Description

Syntax ElementDescription
<node-name>It is a node name we are going to create.
<Property1-name>...<Propertyn-name> Properties are key-value pairs. <Property-name> defines the name of the property which is going to assign to a creating Node

Example

This Example demonstrates On "What will happen if we use RETURN command alone to retrieve data from Database". Follow the steps given below -

Step 1 - Open Neo4j Data Browser.

Step 2 - Type the below command at dollar prompt in Data Browser.

RETURN dept.deptno

Here -

  • dept is a node name
  • deptno is a property name of dept node
Neo4j CQL Tutorial

Step 3 - Click on Execute button and see the success message in the Data Browser.

Neo4j CQL Tutorial

If you observe the error message, it tells us that we cannot use RETURN clause alone. We should use it with either MATCH or CREATE Commands.

In next section, we will discuss about how to use RETURN clause with MATCH Command to retrieve data from Database.

Advertisements