인라인뷰 안의


SELECT * FROM TABLE
(
 MULTISET
 (
  SELECT COUNT (exchange) , alarmid[1,1] , alarmdate
  FROM alarmhisdata WHERE alarmid != 'S5000'
  GROUP BY alarmid[1,1] , alarmdate

                
 UNION ALL   <-- 요기입니다.

                SELECT COUNT (exchange) , alarmid , alarmdate
  FROM alarmhisdata WHERE alarmid = 'S5000'
  GROUP BY alarmid , alarmdate
 )
) A
WHERE ALARMID ='A'