spring data jpa 先排序后分组

最新推荐文章于 2022-05-23 14:22:25 发布

weixin_34297704

最新推荐文章于 2022-05-23 14:22:25 发布

阅读量637

点赞数

文章标签： java python

原文链接：https://my.oschina.net/u/2415642/blog/715465

版权

2019独角兽企业重金招聘Python工程师标准>>>

在 repository层用：
@Query(value = "select myTemperature2 from (select myTemperature from Temperature myTemperature  order by myTemperature.id.time desc) myTemperature1 group by substr(myTemperature1.id.time, 1, 10)")

启服务的时候报错了

解决方案：

@PersistenceContext
private EntityManager entityManager;

String queryString="select * from (select * from Temperature t  order by time desc) t1 group by     substr(t1.time, 1, 10)";
javax.persistence.Query query = entityManager.createNativeQuery(queryString,Temperature.class);
List<Temperature> res=query.getResultList();
System.out.println("##$$$$");
System.out.println(res);
System.out.println("##$$$$");