Postgres 12

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

select version();


version


PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit


CREATE TABLE tbl (id INT, cnt INT, sec INT);
INSERT INTO tbl VALUES (1,10, 1),(2,1,1),(3,25,1),(4,1,1),(5,2,1),(6,10,1),(7,50,2),(8,90,2),(9,90,2);
9 rows affected

with cte as (
SELECT
    id, cnt, sec,
    sum(cnt) over (partition by sec order by cnt,id) sum_
FROM
    tbl )
    
    select 
    id, cnt, sum_,
    case
    when sum_<5 or lag(sum_) over (partition by sec order by cnt,id) <5 then 'false'
    else
    'true'
    end as "show"
    from cte


id
cnt
sum_
show


2
1
1
false

4
1
2
false

5
2
4
false

1
10
14
false

6
10
24
true

3
25
49
true

7
50
50
true

8
90
140
true

9
90
230
true

id	cnt	sum_	show
2	1	1	false
4	1	2	false
5	2	4	false
1	10	14	false
6	10	24	true
3	25	49	true
7	50	50	true
8	90	140	true
9	90	230	true