1. 键盘图
2. 目录
原创2024/5/22小于 1 分钟
select o.pos_no,t.tender_type_id,t.tender_type_desc, sum((case when o.value_sign='N' then -nvl(o.real_value,o.value_) else nvl(o.real_value,o.value_) end)) sale
from h_t_order o,h_t_order_pay p,mom_tender t
where o.id=p.o_id
and p.tender_type_id=t.tender_type_id
and o.belong_date between 20230101 and 20231231
group by o.pos_no,t.tender_type_id,t.tender_type_desc