如何在SQL表中列出3个最大的数字？

SELECT column_name
FROM table_name
ORDER BY column_name DESC
LIMIT 3;

SELECT column_name
FROM table_name
WHERE column_name IN (
    SELECT DISTINCT column_name
    FROM table_name
    ORDER BY column_name DESC
    LIMIT 3
);

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 <= 3;