SELECT sde_density
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 40, sde_feed_cnt, '' ) ),'90.9')) a40_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 60, sde_feed_cnt, '' ) ),'90.9')) a60_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 80, sde_feed_cnt, '' ) ),'90.9')) a80_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 120, sde_feed_cnt, '' ) ),'90.9')) a120_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 150, sde_feed_cnt, '' ) ),'90.9')) a150_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 200, sde_feed_cnt, '' ) ),'90.9')) a200_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 300, sde_feed_cnt, '' ) ),'90.9')) a300_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 400, sde_feed_cnt, '' ) ),'90.9')) a400_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 500, sde_feed_cnt, '' ) ),'90.9')) a500_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 600, sde_feed_cnt, '' ) ),'90.9')) a600_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 700, sde_feed_cnt, '' ) ),'90.9')) a700_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 800, sde_feed_cnt, '' ) ),'90.9')) a800_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 900, sde_feed_cnt, '' ) ),'90.9')) a900_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 1000, sde_feed_cnt, '' ) ),'90.9')) a1000_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 1200, sde_feed_cnt, '' ) ),'90.9')) a1200_Fcnt
FROM TBL_STND_DENSITY
WHERE DEF_TYPE_CD = #setDFT_TYPE_CD#
GROUP BY sde_density
ORDER BY sde_density
-----------------------------------------------------------------------------------------------
SELECT sde_density
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 2, sde_feed_cnt, '' ) ),'90.9')) a2_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 10, sde_feed_cnt, '' ) ),'90.9')) a10_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 20, sde_feed_cnt, '' ) ),'90.9')) a20_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 30, sde_feed_cnt, '' ) ),'90.9')) a30_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 40, sde_feed_cnt, '' ) ),'90.9')) a40_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 50, sde_feed_cnt, '' ) ),'90.9')) a50_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 100, sde_feed_cnt, '' ) ),'90.9')) a100_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 200, sde_feed_cnt, '' ) ),'90.9')) a200_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 250, sde_feed_cnt, '' ) ),'90.9')) a250_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 300, sde_feed_cnt, '' ) ),'90.9')) a300_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 400, sde_feed_cnt, '' ) ),'90.9')) a400_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 500, sde_feed_cnt, '' ) ),'90.9')) a500_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 700, sde_feed_cnt, '' ) ),'90.9')) a700_Fcnt
, TRIM(TO_CHAR(MAX( DECODE( sde_avrwgh, 900, sde_feed_cnt, '' ) ),'90.9')) a900_Fcnt
FROM TBL_STND_DENSITY
WHERE DEF_TYPE_CD = #setDFT_TYPE_CD#
GROUP BY sde_density
ORDER BY sde_density
중복쿼리 ㅠㅠ 이걸 1개로 만들고싶은데 ㅠㅠ 감이 오지않네요 ㅠㅠ
생으로 만들긴했는데 ㅠㅠ 로직상...ㅠㅠ
하나로 어케하면될까요 ㅠㅠ
부탁드릴께요