Question

怎么将这个oracle的sql语句转换成hibernate的hql语句？

select c.id,c.name,nvl(sum(h.count*w.price),0) as money from t_client c left join t_history h on c.id = h.clientid left join t_wares w on w.id = h.waresidgroup by c.id,c.name

Answer 1

用返回map的方式吧。

select c.id,c.name,nvl(sum(h.count*w.price),0) as money

from t_client c left join t_history h on c.id = h.clientid left join t_wares w on w.id = h.waresid
group by c.id,c.name

select new map(c.id,c.name,nvl(sum(h.count*w.price),0) as money)

from Client c left join c.History h left join Wares w

group by c.id, c.name
大概这样，暂时没环境测试。