java - 由另一个实体分组

Question

我正在尝试做

 @Query(value = "select client, sum(price) from PizzaOrder group by client")
 public List<?> topClients();

PizzaOrder包含以下字段的位置：

private Double price;

@ManyToOne
private Client client;

Client类也定义了 equals 和 hashCode。

错误：

Validation failed for query for method public abstract java.util.List packageName.PizzaOrderRepository.topClients()

标签： javahibernatespring-boot

Answer 1

该查询应如下所示：

 @Query(value = "select p.client, sum(p.price) from PizzaOrder p group by p.client")
 public List<?> topClients();

请参阅此 HQL 文档