- WITH C AS (
- SELECT F_163,F_164,F_168,F_174
- ,ROW_NUMBER() OVER(PARTITION BY F_163,F_164 ORDER BY F_163,F_164,F_174 ASC ) AS InComeNO
- FROM T_14 WHERE F_164 <> ''
- )
- SELECT
- F_163 AS 项目名称,F_164 AS 房间编号,
- MAX(CASE WHEN InComeNO = 1 THEN F_174 ELSE NULL END ) AS 第1次收款日期,
- MAX(CASE WHEN InComeNO = 1 THEN F_168 ELSE NULL END ) AS 第1次收款金额,
- MAX(CASE WHEN InComeNO = 2 THEN F_174 ELSE NULL END ) AS 第2次收款日期,
- MAX(CASE WHEN InComeNO = 2 THEN F_168 ELSE NULL END ) AS 第2次收款金额,
- MAX(CASE WHEN InComeNO = 3 THEN F_174 ELSE NULL END ) AS 第3次收款日期,
- MAX(CASE WHEN InComeNO = 3 THEN F_168 ELSE NULL END ) AS 第3次收款金额,
- MAX(CASE WHEN InComeNO = 4 THEN F_174 ELSE NULL END ) AS 第4次收款日期,
- MAX(CASE WHEN InComeNO = 4 THEN F_168 ELSE NULL END ) AS 第4次收款金额
- FROM C
- WHERE 1=1
- GROUP BY F_163,F_164
复制代码
|
|
hessen