spring boot jpa 表关联查询分组 group by 去重

使用jpa操作多张表进行关联查询时，有重复数据需要分组去重

1）确定主表：将有重复数据的表格作为主表，表明关系

public class AttendanceRuleTypeItem implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long itemId;
private String name;
private Integer code;
private String dictionaryCode;
@OneToMany
@JoinColumn(name = “typesCode”,referencedColumnName = “code”)
private List attendanceRules;

}
2.副表两张

public class AttendanceRuleModel {
@Id
@GenericGenerator(name = “guid”, strategy = “guid”)
@GeneratedValue(generator = “guid”)
private String id;
//规则类型code
private Integer ruleCode;
//请假类型code
private Integer typesCode;
//扣罚天数code
private Integer resultNumberCode;

private String rankName;
@OneToOne
@JoinColumn(name = "resultNumberCod