Where Clause for Results Appearing after Occurence
it seems you are looking for something like this:
with cte as 
    (
    select *
        ,row_number() over(order by col_b) as rn
    from dummy
)
select * 
from cte
where rn &gt; (select rn from cte where col_a = 'A' and col_b = 'B' and col_c = 'C' and test = 1 limit 1)