Question

hql order by 加两个条件就 报错

操作失败！unexpected token: ASC，c near line 1, column 79 [FROM nsfw.complain.entity.Complain c WHERE c.compName = ? ORDER BY c.compTime ASC，c.state DESC]
compTime state 两个属性都有，单独使用其中一个排序就可以 ，两个一起就不行

Answer 1

f1用升序， f2降序
ORDER BY f1, f2 DESC
也可以这样写，更清楚：
ORDER BY f1 ASC, f2 DESC
如果都用降序，必须用两个desc
ORDER BY f1 DESC, f2 DESC