Oracle 11g Release 2

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

CREATE TABLE users (
  id INT NOT NULL,
  name VARCHAR(30) NOT NULL,
  num int NOT NULL
)
INSERT INTO users (id, name, num) 
select 1,'alan',5 from dual union all
select 2,'alan',4 from dual union all
select 3,'julia',10 from dual union all
select 4,'maros',77 from dual union all
select 5,'alan',1 from dual union all
select 6,'maros',14 from dual union all
select 7,'fero',1 from dual union all
select 8,'matej',8 from dual union all
select 9,'maros',55 from dual
9 rows affected

select us.*, last_value(num) over (order by name) as lv
from users us;


ID
NAME
NUM
LV


5
alan
1
5

2
alan
4
5

1
alan
5
5

7
fero
1
1

3
julia
10
10

6
maros
14
77

9
maros
55
77

4
maros
77
77

8
matej
8
8


select us.*, last_value(num) over (partition by name order by num RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as lv
from users us;


ID
NAME
NUM
LV


5
alan
1
5

2
alan
4
5

1
alan
5
5

7
fero
1
1

3
julia
10
10

6
maros
14
77

9
maros
55
77

4
maros
77
77

8
matej
8
8


select us.*, first_value(num) over (order by name desc) as lv
from users us;


ID
NAME
NUM
LV


8
matej
8
8

6
maros
14
8

9
maros
55
8

4
maros
77
8

3
julia
10
8

7
fero
1
8

5
alan
1
8

2
alan
4
8

1
alan
5
8

ID	NAME	NUM	LV
5	alan	1	5
2	alan	4	5
1	alan	5	5
7	fero	1	1
3	julia	10	10
6	maros	14	77
9	maros	55	77
4	maros	77	77
8	matej	8	8