Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
0


-- Create the table
CREATE TABLE jobs_errors (
    JOB VARCHAR2(10),
    errors NUMBER
);

INSERT ALL
    INTO jobs_errors (JOB, errors) VALUES ('A', 15)
    INTO jobs_errors (JOB, errors) VALUES ('B', 17)
    INTO jobs_errors (JOB, errors) VALUES ('C', 29)
    INTO jobs_errors (JOB, errors) VALUES ('D', 27)
    INTO jobs_errors (JOB, errors) VALUES ('E', 35)
    INTO jobs_errors (JOB, errors) VALUES ('F', 32)
    INTO jobs_errors (JOB, errors) VALUES ('G', 75)
    INTO jobs_errors (JOB, errors) VALUES ('H', 31)
    INTO jobs_errors (JOB, errors) VALUES ('I', 12)
    INTO jobs_errors (JOB, errors) VALUES ('J', 10)
SELECT * FROM dual;
10 rows affected

WITH total_errors_cte AS (
    -- Calculate the total errors for all jobs
    SELECT SUM(errors) AS total_errors
    FROM jobs_errors
),
running_sum_cte AS (
    -- Calculate the running sum of errors, ordered by errors DESC
    SELECT JOB, errors, 
           (SELECT total_errors FROM total_errors_cte) AS total_errors,
           (
               SELECT SUM(errors)
               FROM jobs_errors x
               WHERE x.errors >= t.errors
           ) AS running_sum
    FROM jobs_errors t
)
-- Filter jobs whose running sum is <= 40% of total errors
SELECT JOB, errors
FROM running_sum_cte
WHERE running_sum <= total_errors * 0.4
ORDER BY errors DESC;


JOB
ERRORS


G
75

E
35