Postgres 12

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

select version();


version


PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit



SELECT 1


create table matches (
       id       serial      
     , kills    int4 not null 
     , deaths   int4 not null 
     , assists  int4 not null 
     , gamemode int4 not null 
     ) ;
    
alter table matches add other1 text; 
alter table matches add other4 text; 
     
insert into matches (id, kills, deaths, assists, gamemode) 
     values  (1, 0, 0, 3, 1)
           , (2, 1, 0, 2, 2) 
           , (3, 1, 12, 0, 3)
           , (4, 7, 2, 27, 1)
           , (5, 1, 4, 27, 2)
           , (6, 2, 3, 1, 3);

CREATE TABLE



ALTER TABLE



ALTER TABLE



INSERT 0 6


select m.*
     , max(m.kills )    over (partition by '') max_kills
     , max(m.deaths )   over (partition by '') max_deaths
     , max(m.assists )  over (partition by '') max_assists
     , max(m.gamemode ) over (partition by '') max_gamemode  
 from matches m;  


id
kills
deaths
assists
gamemode
other1
other4
max_kills
max_deaths
max_assists
max_gamemode


1
0
0
3
1
null
null
7
12
27
3

2
1
0
2
2
null
null
7
12
27
3

3
1
12
0
3
null
null
7
12
27
3

4
7
2
27
1
null
null
7
12
27
3

5
1
4
27
2
null
null
7
12
27
3

6
2
3
1
3
null
null
7
12
27
3



SELECT 6

id	kills	deaths	assists	gamemode	other1	other4	max_kills	max_deaths	max_assists	max_gamemode
1	0	0	3	1	null	null	7	12	27	3
2	1	0	2	2	null	null	7	12	27	3
3	1	12	0	3	null	null	7	12	27	3
4	7	2	27	1	null	null	7	12	27	3
5	1	4	27	2	null	null	7	12	27	3
6	2	3	1	3	null	null	7	12	27	3