sql - How to skip with other further records when reached condition?

Question

I have SQL issue. Lets suppose we have record:

In above record we need to select record with Cancel but only 2 starting not all with Cancel. There may be multiple Cancel on Top or anywhere.

Please help me to create query for that.

Answer 1

With NOT EXISTS:

select t.* from tablename t
where col = 'Cancel'
  and not exists (
  select 1 from tablename
  where creation_date < t.creation_date and col <> t.col
)  

See the demo.