SQL查找表中的五个最大数而不是一个最大数

SELECT column_name
FROM table_name
ORDER BY column_name DESC
LIMIT 5;

SELECT column_name
FROM table_name
WHERE column_name IN (
    SELECT TOP 5 column_name
    FROM table_name
    ORDER BY column_name DESC
);

SELECT column_name
FROM (
    SELECT column_name, ROW_NUMBER() OVER (ORDER BY column_name DESC) AS row_num
    FROM table_name
) AS subquery
WHERE row_num <= 5;