Function max() finds and returns the maximum row value in an alias (ignoring the rows that are null). Only one row from the alias will be kept after this function is called, and all the rest rows will be abandoned.

Arguments：

• Alias <number | time>

Returns：

• Max value <number | time>

Sample graph: (to be used for the following examples)

create().node_schema("professor").node_schema("student")
create().node_property(@*, "age", int32).node_property(@*, "email", string)
insert().into(@professor).nodes([{_id:"P001",_uuid:1,age:53,email:"test@yahoo.cn"},{_id:"P002",_uuid:2,age:27,email:"test@ultipa.com"}])
insert().into(@student).nodes([{_id:"S001",_uuid:3,age:27,email:"test@yeah.net"},{_id:"S002",_uuid:4,age:20,email:"test@w3.org"},{_id:"S003",_uuid:5,age:25,email:"test@gmail.com"}])

Comman Usage

Example: Calculate the maximum age of all nodes in the graph

find().nodes() as n
return max(n.age)

53