Oracle 21c

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

create table tags(name varchar(10), tag int);
insert into tags values ('a', 200);
1 rows affected

insert into tags values ('b', 400);
1 rows affected

insert into tags values ('c', null);
1 rows affected

insert into tags values ('d', null);
1 rows affected

insert into tags values ('e', null);
1 rows affected

insert into tags values ('f', 100);
1 rows affected

insert into tags values ('g', null);
1 rows affected

insert into tags values ('h', null);
1 rows affected

insert into tags values ('i', null);
1 rows affected

insert into tags values ('j', 500);
1 rows affected

Select Name, tag as tag_original, coalesce(Tag, lag(Tag) IGNORE NULLS over (order by Name)) as Tag from tags;


NAME
TAG_ORIGINAL
TAG


a
200
200

b
400
400

c
null
400

d
null
400

e
null
400

f
100
100

g
null
100

h
null
100

i
null
100

j
500
500

NAME	TAG_ORIGINAL	TAG
a	200	200
b	400	400
c	null	400
d	null	400
e	null	400
f	100	100
g	null	100
h	null	100
i	null	100
j	500	500