如:select u.a,avg(u.b) from User u group by u.a order by [color=red]聚合这列[/color]给聚合这列加不起别名,,请问有与到过此类问题的没啊,,,,
直接hql: order by avg(u.b)就可以了。
select u.a,avg(u.b) as '别名' from User u group by u.a order by avg(u.b)