1.Unpivot列转行
源表:
SELECT YEAR,
period,
entity_code,
entity_desc,
dept_code,
dept_desc,
supplier_code,
supplier_desc,
business_type,
account,
VALUE
FROM stg_ts_advance_pay unpivot(VALUE FOR account IN(advance_cny AS
'预付款申请金额(人民币)',
contract_amount_cny AS
'预付款采购合同额(人民币)',
contract_amount_cny AS
'合同额(人民币)',
contract_amount_usd AS
'合同额(美元)'))
结果展示:&