数据源头是这样的
最后展示的数据需要是这样的
sql语句如下:
SELECT SUBSTR
(SFQJMC,
1
,
4
) XN,
trim
(T.XH) XH,
SUBSTR
(SFQJMC,
1
,
4
) JFXN,
SUM
(
DECODE
(
T.SFXMMC
,
'学费'
,
T.SJJE
))
XF
,
SUM
(
DECODE
(
TRIM
(
T.SFXMMC
),
'住宿费'
,
T.SJJE
))
ZSF
,
SUM
(
DECODE
(
TRIM
(
T.SFXMMC
),
'代收教材'
,
T.SJJE
))
SBF
,
SUM
(
DECODE
(
TRIM
(
T.SFXMMC
),
'大学生医保'
,
T.SJJE
))
YBF
,
CASE
WHEN
QFJE
=
0
THEN
'已缴清'
ELSE
'欠费'
||
QFJE
||
'元'
END
BZ
FROM
LYSDC.LY_XXBZ_GXXS_JNXFZL T
GROUP BY SUBSTR
(SFQJMC,
1
,
4
) ,T.XH,
CASE WHEN QFJE
=
0
THEN
'已缴清'
ELSE
'欠费'
||
QFJE
||
'元'
END