DB2行转列

SELECT REAL_CDEP_BAL 活期存款  ,REAL_TDEP_BAL 定期存款 FROM ACRM_A_CI_PER_GATH_BUSINESS WHERE CUST_ID = '1111'

查询结果如下：

SELECT
    QUARTER,
    RESULTS
FROM
    (
       SELECT
            REAL_CDEP_BAL,
            REAL_TDEP_BAL
        FROM
            ACRM_A_CI_PER_GATH_BUSINESS
        WHERE
            cust_id = '1111') S,
    TABLE(VALUES
    ('活期存款', S.REAL_CDEP_BAL)
    , ('定期存款', S.REAL_TDEP_BAL)) AS Q(QUARTER, RESULTS)
WHERE

    RESULTS > 0

结果如下：