MySQL 8.0

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

CREATE TABLE tbl (server VARCHAR(20), payment INT);

INSERT INTO tbl (server, payment)
VALUES
('alpha', 87),
('alpha', 83),
('alpha', 82),
('alpha', 36),
('beta', 89),
('beta', 74),
('beta', 42),
('beta', 34);
select * from tbl;


server
payment


alpha
87

alpha
83

alpha
82

alpha
36

beta
89

beta
74

beta
42

beta
34


WITH rs (server, payment, seq) AS
(
	SELECT * 
		, ROW_NUMBER() OVER (PARTITION BY server ORDER BY payment DESC) AS seq
	FROM tbl
)
SELECT * 
FROM rs
WHERE seq <= 3;


server
payment
seq


alpha
87
1

alpha
83
2

alpha
82
3

beta
89
1

beta
74
2

beta
42
3