RETURN
The RETURN clause defines which properties and values the result-set will contain.
Basic Usage
The basic structure is a comma-separated list of alias.property expressions:
RETURN person.name, person.age
For convenience, you can specify just the alias to return all properties of an entity:
RETURN movie.title, actor
Removing Duplicates
Use the DISTINCT keyword to remove duplicate values from the result-set:
RETURN DISTINCT friend_of_friend.name
For example, if you have two friends (Joe and Miesha) who both know Dominick, DISTINCT ensures that Dominick appears only once in the final result set.
Aggregations
The RETURN clause can also aggregate data, similar to SQL's GROUP BY functionality.
When an aggregation function is used in the RETURN list, all non-aggregated values become implicit grouping keys:
RETURN movie.title, MAX(actor.age), MIN(actor.age)
This query groups data by movie title and, for each movie, returns the youngest and oldest actor ages.
Supported Aggregation Functions
| Function | Description |
|---|---|
avg | Calculate average of numeric values |
collect | Collect values into a list |
count | Count number of values |
max | Find maximum value |
min | Find minimum value |
percentileCont | Calculate continuous percentile |
percentileDisc | Calculate discrete percentile |
stDev | Calculate standard deviation |
sum | Calculate sum of numeric values |
For detailed information on aggregation functions, see the Functions documentation.