아래 쿼리를 첫번째 select절을 제외하고 하나의 쿼리로 묶을수 있을거 같아서

문의 드립니다.

rollup으로 하면 될거 같긴한데

잘안되서 도움 부탁드립니다.. 

SELECT '0' gbn, '0' gbn1,'0' gbn2, '1' gbn3     
 , PROD  
 , PL_NM    
 , CH_CD

 , CH_NM

 , IT_CD     
 , IT_NM     
 , SPEC      
 , IT_SPEC2     
 , AMT_1   
FROM RESULT      

UNION ALL     

SELECT '0' gbn, '0' gbn1,'0' gbn2, '1' gbn3     
 ,PROD as PROD      
 ,PL_NM as PL_NM      
 ,CH_CD as CH_CD      
 ,CH_NM as CH_NM      
 ,''IT_CD     
 ,'소계' IT_NM     
 ,' ' SPEC      
 ,' ' IT_SPEC2     
 , SUM(AMT_1) AMT_1   
FROM RESULT     
GROUP BY PROD_BUSI, PLANT_NM,CH_CD,CH_NM     
     
UNION ALL     
     
SELECT '0' gbn, '0' gbn1,'1' gbn2, '1' gbn3     
 ,PROD as PROD      
 ,PL_NM as PL_NM      
 ,''CH_CD      
 ,'중간합계'CH_NM      
 ,' 'IT_CD     
 ,' ' IT_NM     
 ,' ' SPEC      
 ,' ' IT_SPEC2     
 , SUM(AMT_1) AMT_1   
FROM RESULT     
GROUP BY PROD_BUSI, PLANT_NM     
     
UNION ALL     
     
SELECT '1' gbn, '1' gbn1,'1' gbn2, '1' gbn3     
 ,' ' PROD      
 ,'총계'PL_NM      
 ,' 'CH_CD      
 ,''CH_NM      
 ,' 'IT_CD     
 ,' ' IT_NM     
 ,' ' SPEC      
 ,' ' IT_SPEC2     
 , SUM(AMT_1) AMT_1   
FROM RESULT     
ORDER BY gbn, gbn1, PROD, gbn2, CH_CD desc, gbn3, it_cd, IT_NM