Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of: uppercase, lowercase, numbers, and special characters.
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Apply New License

License Detail

Please complete this required field.

  • Ultipa Graph V4

Standalone

Please complete this required field.

Please complete this required field.

The MAC address of the server you want to deploy.

Please complete this required field.

Please complete this required field.

Cancel
Apply
ID
Product
Status
Cores
Applied Validity Period(days)
Effective Date
Excpired Date
Mac Address
Apply Comment
Review Comment
Close
Profile
  • Full Name:
  • Phone:
  • Company:
  • Company Email:
  • Country:
  • Language:
Change Password
Apply

You have no license application record.

Apply
Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Product Created On ID Amount (USD) Invoice
Product Created On ID Amount (USD) Invoice

No Invoice

Search
    English

      ORDER BY

      ORDER BY adjusts the order of rows in the alias.

      Syntax: ORDER BY <expression> <string>, <expression> <string>, ...
      Input:

      • <expression>: Sorting criterion; multiple criteria must be homologous and are operated from left to right
      • <alias>: Fashion of sorting, either ASC or DESC (case insensitive), or ASC when omitted

      For instance, adjusts the order of one-step paths path, first into descending radius of terminal-nodes n, then into ascending ID of n if n shares the same radius.

      n([4, 2]).e().n(as n) as path
      order by n.radius desc, n
      return path
      

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

      Run below UQLs one by one in an empty graphset to create graph data:

      create().node_schema("student").node_schema("course")
      create().node_property(@*, "name").node_property(@student, "age", int32).node_property(@course, "credit", int32)
      insert().into(@student).nodes([{_id:"S001", _uuid:1, name:"Jason", age:25}, {_id:"S002", _uuid:2, name:"Lina", age:23}, {_id:"S003", _uuid:3, name:"Eric", age:24}, {_id:"S004", _uuid:4, name:"Emma", age:26}, {_id:"S005", _uuid:5, name:"Pepe", age:24}])
      insert().into(@course).nodes([{_id:"C001", _uuid:6, name:"French", credit:4}, {_id:"C002", _uuid:7, name:"Math", credit:5}])
      insert().into(@default).edges([{_uuid:1, _from_uuid:1, _to_uuid:6}, {_uuid:2, _from_uuid:2, _to_uuid:6}, {_uuid:3, _from_uuid:3, _to_uuid:6}, {_uuid:4, _from_uuid:2, _to_uuid:7}, {_uuid:5, _from_uuid:3, _to_uuid:7}, {_uuid:6, _from_uuid:4, _to_uuid:7}, {_uuid:7, _from_uuid:5, _to_uuid:7}])
      

      Grouping and Ordering

      Example: Find 1-step paths @course-@student, group by course and calculate number of students in each group, and order the results into descening count

      n({@course} as a).e().n({@student})
      group by a
      with count(a) as b
      order by b desc 
      return table(a.name, b)
      

      | a.name | b |
      |--------|---|
      | Math   | 4 |
      | French | 3 |
      

      多级排序

      Example: Find 1-step paths @course-@student, order the results into ascending credit of course, then into descending age of student

      n({@course} as a).e().n({@student} as b) as p
      order by a.credit, b.age desc 
      return p{*}
      

      French <---- Jason
      French <---- Eric
      French <---- Lina
      Math <---- Emma
      Math <---- Eric
      Math <---- Pepe
      Math <---- Lina
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写