hibernate 怎么用别名排序
"select a.v_rec_id,a.v_title,(select count(*)from Answer as r where r.v_question_rec_id=a.v_rec_id) as val from Ask as a where a.v_flag='0' order by val desc";
09:14:32,781 ERROR JDBCExceptionReporter:78 - Unknown column 'val' in 'order clause'错误 这个要怎么办怎么办怎么办
[解决办法]
你试试这样ok不
select a.v_rec_id,a.v_title,count(a.v_rec_id) val
from Ask a,Answer r
where r.v_question_rec_id=a.v_rec_id
and a.v_flag='0'
group by a.v_rec_id
order by val desc
[解决办法]
select a.v_rec_id,
a.v_title,
count(a.v_rec_id) as val
from Ask as a
left join Answer as r
on r.v_question_rec_id = a.v_rec_id
where a.v_flag = '0'
group by a.v_rec_id,a.v_title
order by val desc
