Postgres 14

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

CREATE TABLE tbl (
  id int PRIMARY KEY
, dollars int
, dollars_rank int
, points int
, points_rank int
);

 INSERT INTO tbl VALUES
  (1, 20, 1, 35, 1)
, (2, 18, 2, 30, 3)
, (3, 10, 3, 33, 2)
, (4, 10, 3, 33, 2)  -- Added dupe row to demonstrate ties.
;

CREATE TABLE



INSERT 0 4


TABLE tbl;


id
dollars
dollars_rank
points
points_rank


1
20
1
35
1

2
18
2
30
3

3
10
3
33
2

4
10
3
33
2



SELECT 4


UPDATE tbl
SET    dollars_rank = r.d_rnk
     , points_rank  = r.p_rnk
FROM  (
	SELECT id
	     , dense_rank() OVER (ORDER BY dollars DESC NULLS LAST) AS d_rnk
	     , dense_rank() OVER (ORDER BY points  DESC NULLS LAST) AS p_rnk
	FROM   tbl
	) r
WHERE  tbl.id = r.id
RETURNING *;


id
dollars
dollars_rank
points
points_rank
id
d_rnk
p_rnk


1
20
1
35
1
1
1
1

2
18
2
30
3
2
2
3

3
10
3
33
2
3
3
2

4
10
3
33
2
4
3
2



UPDATE 4