For the complete documentation index, see llms.txt. This page is also available as Markdown.

分组映射

对于GROUP BY子句,通常分组字段也需要出现在返回列中,可通过在视图类字段上添加注解声明其为分组列,并在映射时添加到GROUP BY后。

示例

定义视图对象时,在用于分组的字段上添加@GroupBy注解:

@GroupBy
private int returnFlag;

@GroupBy
private int lineStatus;

带有@GroupBy注解的字段被映射为:

SELECT return_flag, line_status, ... FROM ...
GROUP BY return_flag, line_status ...

最后更新于