SQL Server 2019 (Linux)

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

CREATE TABLE numbers(nums integer);
INSERT INTO numbers  VALUES (10), (9), (8), (8), (2), (10);
6 rows affected

SELECT TOP 3 WITH TIES * FROM numbers ORDER BY nums DESC;

nums

10

10

9

SELECT TOP 4 WITH TIES * FROM numbers ORDER BY nums DESC;

nums

10

10

9

8

8

SELECT nums
FROM  (SELECT nums, rank() OVER (ORDER BY nums DESC) as rn FROM numbers) t
WHERE  rn <= 3;

nums

10

10

9

SELECT nums
FROM  (SELECT nums, rank() OVER (ORDER BY nums DESC) as rn FROM numbers) t
WHERE  rn <= 4;

nums

10

10

9

8

8