在 hibernate3.2里select o.outprovid,count(o.orderid),sum(case when o.orderalready='1' then o.spprice else 0 end) from Ordertb o 这样可以
但是改成sum(case when o.orderalready='1' then o.spprice*o.num else 0 end)
就报不支持*的 错误
但是改成sum(case when o.orderalready='1' then o.spprice*o.num else 0 end)
就报不支持*的 错误
sum(case when o.orderalready='1' then o.spprice*o.num else 0 end)
将它放在外面,结果是一样的sum(case when o.orderalready='1' then o.spprice else 0 end)*o.num
List a = manager.getList("select o.outprovid,count(o.orderid),sum(case when o.orderalready='1' then o.spprice else 0 end)*o.ordernum,sum(case when o.orderalready='1' then o.orderprice else 0 end)*o.ordernum,sum(case when o.orderalready='1' then (o.spprice-o.orderprice) else 0 end)*o.ordernum from Ordertb o where o.outprovid='"+prov.getOutProvid()+"' and o.worktime>? and o.worktime<? group by o.outprovid",new Object[]{ts,te});还是不行