CREATE TABLE err_log (id NUMBER, err_typ VARCHAR2(2))
/

BEGIN
INSERT INTO err_log values (1, 'E');
--
INSERT INTO err_log values (2, 'E');
INSERT INTO err_log values (2, 'F');
INSERT INTO err_log values (2, 'E');
INSERT INTO err_log values (2, 'F');
--
INSERT INTO err_log values (3, 'E');
INSERT INTO err_log values (3, 'F');
--
INSERT INTO err_log values (4, 'E');
INSERT INTO err_log values (4, 'E');
--
INSERT INTO err_log values (5, 'F');
INSERT INTO err_log values (5, 'F');
--
INSERT INTO err_log values (6, 'E');
END;
/

Output: 
ID	ERR_TYP

1	E
4	E
4	E
6	E

SELECT   b.ID, b.err_typ
    FROM (SELECT   ID, COUNT (DISTINCT err_typ) cnt
              FROM err_log
          GROUP BY ID
            HAVING COUNT (DISTINCT err_typ) = 1) a,
         err_log b
   WHERE a.ID = b.ID AND b.err_typ = 'E'
ORDER BY 1

SQL> select id, err_typ
  2  from (select id, err_typ, max(err_typ) over (partition by id) max_err
  3        from err_log)
  4  where max_err = 'E'
  5  /
        ID ER
---------- --
         1 E
         4 E
         4 E
         6 E

select a.id,a.err_type
from err_log a
where a.err_type = 'E'
and not exists
(select null
 from err_log b
 where b.id = a.id
 and  b.err_type = 'F');

select a.id, a.err_typ
from err_log a left outer join err_log b
     on b.id = a.id and b.err_typ = 'F'
where a.err_typ = 'E' and b.id is null
/