I have a table that looks like this
You can use the analytical function count as follows
count
Select * from (Select t.*, Count(distinct col2) over (partition by col1) as c From your_table t) t Where c > 1
2.1m questions
2.1m answers
60 comments
56.9k users