Postgres -如何找到与某一列的最大交集的行

SELECT *
FROM your_table
WHERE your_column IN (
    SELECT your_column
    FROM your_table
    GROUP BY your_column
    HAVING COUNT(*) = (
        SELECT MAX(count)
        FROM (
            SELECT COUNT(*) AS count
            FROM your_table
            GROUP BY your_column
        ) AS counts
    )
);