By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (id int, myname varchar(20), pay int)
insert into test values (1, 'Mark', 100)
insert into test values (1, 'Mark', 100)
insert into test values (2, 'Ann', 100)
Select id, myname, sum(pay)
from test
group by id, myname
| id | myname | sum(pay) |
|---|---|---|
| 1 | Mark | 200 |
| 2 | Ann | 100 |
Select sum(pay)
from test;
| sum(pay) |
|---|
| 300 |