SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table t (id serial, v char); insert into t (v) values ('a'),(null),(null),(null),('b'),(null),(null); select id, first_value(v) over (partition by grp order by id) from (select id, v, case when v is not null and lead(v) over (order by id) is null then lead(grp) over (order by id) else grp end grp from (select id, v, ROW_NUMBER() OVER(ORDER BY ID) - ROW_NUMBER() OVER(PARTITION BY (CASE WHEN v IS NOT NULL THEN 1 ELSE 0 END) ORDER BY ID) grp from t) T1 ) T2;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear