This is close:

WITH cteList(col1, col2, freq) AS

(SELECT col1, col2, count(*) OVER (PARTITION BY col1, col2) AS Freq

FROM (

SELECT 'John' AS col1,1 as col2,1 as col3

UNION ALL

SELECT 'John',1,1

UNION ALL

SELECT 'John',2,2

UNION ALL

SELECT 'John',3,3

UNION ALL

SELECT 'John',3,3

UNION ALL

SELECT 'John',4,4) x

)

SELECT col1, col2, freq

FROM cteList

WHERE freq>1;