我需要在hql查询中对订单进行条件调整。name)sortOrder (asc或desc)列select a from TableA a, TableB b, TableC c WHERE a.column1' THEN 'a.column3 asc' ELSE 'a.column3 desc' END) WHEN :sortBy = column4 THEN (CASE WHEN :
我正在使用spring boot和jpa存储库,我想使用hql查询从数据库中获取最后2条记录。我已经写了下面的查询,但它不工作。@Query("select news from(select news from NewsDTO news order by news.newsId desc limit 2) sub order bynews.newsId asc") 它正在抛出下面的异常 Caused by: org.hibernate.hql.internal.ast.QuerySyn
我在inserted_at和x列上有索引。where order by a.inserted_at asctable_a a where a.inserted_at >= '2018-09-01 00:00:00.0' and a.x in ('some_x_val') order by a.inserted_at as
我有可用的HQL代码: @Query("SELECT prod FROM Product as prod ORDER BY prod.rating ASC") List<Product> findProductsByRating(String orderDir); 其中orderDir可以是ASC或DESC