分组映射
@GroupBy
private int returnFlag;
@GroupBy
private int lineStatus;SELECT return_flag, line_status, ... FROM ...
GROUP BY return_flag, line_status ...最后更新于
对于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 ...最后更新于