你如何选择TOP x,但仍然得到整个查询的COUNT？

SELECT *
FROM (
    SELECT column_name, COUNT(*) as count
    FROM table_name
    GROUP BY column_name
    ORDER BY count DESC
    LIMIT x
) AS top_x
JOIN (
    SELECT COUNT(*) as total_count
    FROM table_name
) AS total

SELECT column_name, COUNT(*) as count, SUM(COUNT(*)) OVER () as total_count
FROM table_name
GROUP BY column_name
ORDER BY count DESC
LIMIT x