Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (server, component, status) AS
  SELECT 'A', 'C1', 'OK'    FROM DUAL UNION ALL
  SELECT 'A', 'C2', 'OK'    FROM DUAL UNION ALL
  SELECT 'B', 'C1', 'OK'    FROM DUAL UNION ALL
  SELECT 'B', 'C2', 'ERROR' FROM DUAL;
4 rows affected

SELECT server,
       component,
       MIN(status) AS status
FROM   table_name
GROUP BY ROLLUP(server, component)
HAVING GROUPING_ID(server) = 0
ORDER BY server, component


SERVER
COMPONENT
STATUS


A
C1
OK

A
C2
OK

A
null
OK

B
C1
OK

B
C2
ERROR

B
null
ERROR


SELECT server,
       component,
       MIN(status) AS status
FROM   table_name
GROUP BY ROLLUP(server, component)
HAVING GROUPING_ID(server, component) < 3
ORDER BY server, component


SERVER
COMPONENT
STATUS


A
C1
OK

A
C2
OK

A
null
OK

B
C1
OK

B
C2
ERROR

B
null
ERROR