SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE student ( id SERIAL PRIMARY KEY, State VARCHAR(255) NOT NULL ); INSERT INTO student(State) VALUES ('Suc'), ('Suc'), ('Fail'), ('Suc'), ('Suc'), ('Suc'), ('Fail'), ('Fail'), ('Suc'), ('Suc'), ('Fail'), ('Fail'), ('Fail'), ('Fail'); select * from student s inner join ( select * from ( select *, coalesce (lead(id) over (), (select count(state) from student)) - id as streamlen from (select * from (select id, state, lag(state) over () as prevstate from student ) s2 where s2.prevstate != state or s2.prevstate is null ) s3 )s4 ) s5 on s.id between s5.id and (s5.id + s5.streamlen - 1) where streamlen = 3