在springdatajpa中使用hql查询实现Optimal结果的最佳方法

Question

因为在spring的@query中不支持limit，所以我们需要使用除分页查询参数之外的其他方法

Answer 1

 @Query(" select something so where so.id>50 order by so.created desc")
    @QueryHints(@QueryHint(name = "org.hibernate.annotations.FETCH_SIZE" , value = "1"))
optionam<something> findlatestSomething();

Answer 2

@Query(" select something s where s.id = select max(so.id) something so order by so.id desc")
optionam<something> findlatestSomething();