Oracle 18c

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

create table xx ( id int, amount int );
insert into xx ( id, amount ) VALUES (2,4);
1 rows affected

insert into xx ( id, amount ) VALUES (2,4);
1 rows affected

insert into xx ( id, amount ) VALUES (2,4);
1 rows affected

insert into xx ( id, amount ) values (1, 5);
1 rows affected

insert into xx ( id, amount ) VALUES (3,7);
1 rows affected

insert into xx ( id, amount ) VALUES (3,7);
1 rows affected

insert into xx ( id, amount ) values (1, 5);
1 rows affected

insert into xx ( id, amount ) values (4, 7);
1 rows affected

select id, amount, sum(DISTINCT amount) over () as total 
  from xx;


ID
AMOUNT
TOTAL


2
4
16

2
4
16

2
4
16

1
5
16

1
5
16

3
7
16

3
7
16

4
7
16


select id, amount, sum(DISTINCT amount) over (ORDER BY id) as total 
  from xx; --Here I expect 23 for Total
ORA-30487: ORDER BY not allowed here