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 Blaze (v4)

Standalone

Please complete this required field.

Please complete this required field.

Please complete this required field.

Please complete this required field.

Leave it blank if an HDC service is not required.

Please complete this required field.

Leave it blank if an HDC service is not required.

Please complete this required field.

Please complete this required field.

Mac addresses of all servers, separated by line break or comma.

Please complete this required field.

Please complete this required field.

Cancel
Apply
ID
Product
Status
Cores
Maximum Shard Services
Maximum Total Cores for Shard Service
Maximum HDC Services
Maximum Total Cores for HDC Service
Applied Validity Period(days)
Effective Date
Expired Date
Mac Address
Reason for Application
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

v4.5
Search
    English
    v4.5

      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 |
      

      Multi-level Ordering

      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
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写