(在SSMS2016中工作)我有一个表,如下:|--------------|---------1 | 1 |SELECT ORDER_NUMBER, ITEM_CAT, SUM(ORDER_QTY) AS 'ORDER_QTY', SUM(UNALLOCATED) AS 'UNALLOCATED' GROUP BY
这是我的疑问 SELECT sum(advance) as advance, sum(advance_unallocated) as advance_unallocated FROM`deals` SELECT
d.id as did,sum(d.advance_unallocated) as advance_unallocated,sum(pb.
我需要基于o_unallocated_ledgercode和供应商获得两个值(o_allocated_ledgercode和paymentType )。 o_allocated_ledgercode out varchar2,BEGIN
IF UPPER (i_payment_type) = 'SUBS