SQL - Find Most Frequent Value in SQL Column

SELECT TOP 1 

    'Value',

    COUNT('Value') AS 'Value_Occurrence' 

FROM     

    'My_Table'

GROUP BY 

    'Value'

ORDER BY 

    'Value_Occurrence' DESC;

SELECT TOP 1 COLUMN, COUNT(COLUMN) AS MOST_FREQUENT

FROM TABLE_NAME

GROUP BY COLUMN

ORDER BY COUNT(COLUMN) DESC