我编写了一个查询,在该查询中,我有一个条件,可以按以下顺序按多个列对数据进行排序。ORDER BY Column1 ASC, Column2 ASC, Column3 ASCORDER BY Column1 DESC, Column2 DESC, Column3 DESC
我想按表达式按条件排序= 'Id DESC' THEN Id EN
我需要在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 :sortOrder ='<