›Calculating Min/Max Values
3.5 · Lesson
Calculating Min/Max Values
Unlike the iFull definition for aggregation (opens in a new tab)Grouping rows and computing a value over each group. In Cypher the grouping keys are whatever expressions in the same clause are not aggregated. functions sum() and avg(), the min and max functions evaluate values that could represent mixed types.
The types could be numeric, strings, or lists.
Like sum() and avg(), null elements are ignored.
A numeric value is always greater than a string or list value. This query returns 2 because it is the greatest numeric value.
Join GraphAcademy to keep learning
Create your account to unlock 80+ hours of hands-on Neo4j courses, track your progress, and earn a certificate when you complete the course.
Sign in or register