Question

求:帮我将这条SQL语句转成HQL...

update goods set price = (select sum(price) from io_goods where io_goods.goodsid=777) where goods.goods_id=777;

请问一下求差语句怎么弄.
select sum(price) from io_goods where io_goods.goodsid=777 and io_goods.ioless=0;
select sum(price) from io_goods where io_goods.goodsid=777 and io_goods.ioless=1;
将上面select 出来的两个值相减? 将0的减去1的..

Answer 1

select top 1 ((select sum(price) from io_goods where io_goods.goodsid=777 and io_goods.ioless=0)-(select sum(price) from io_goods where io_goods.goodsid=777 and io_goods.ioless=1)) as 求差 from io_goods

Answer 2

可以搞的简单点~~~~

select sum(case when goodsid=777 and ioless=0 then price end)-sum(case when goodsid=777 and ioless=1 then price end)
from io_goods