ArangoDb学习笔记————High-level operations（二）

COLLECT：

这个关键词类似于Oracle的group by，用法比较多。

COLLECT variableName = expression
COLLECT variableName = expression INTO groupsVariable
COLLECT variableName = expression INTO groupsVariable = projectionExpression
COLLECT variableName = expression INTO groupsVariable KEEP keepVariable
COLLECT variableName = expression WITH COUNT INTO countVariable
COLLECT variableName = expression AGGREGATE variableName = aggregateExpression
COLLECT variableName = expression AGGREGATE variableName = aggregateExpression INTO groupsVariable
COLLECT AGGREGATE variableName = aggregateExpression
COLLECT AGGREGATE variableName = aggregateExpression INTO groupsVariable
COLLECT WITH COUNT INTO countVariable

1.第一个用法就是简单的分组，用例子来说话，用之前的Charaters来举例子。

surname就是外国人的姓，现在有这么需求，就是想看看都有哪些家族的人。

FOR c IN Characters
  COLLECT surname = c