How can I find groups in a SQL data set?

  Kiến thức lập trình

I have a SQL table with two columns like this with about 130k rows. (9k unique users, 7500 unique skills)

User Skill
A 1
A 2
B 3
C 1

I’m trying to understand (and possibly visualize) the number of users who share the same skills sets. I don’t know which skills overlap today.

I want some output of Group A {Skills: 1 & 2 & 7} has 10 people
I want some output of Group B {Skills: 10 & 95} has 19 people, etc…

Thanks for your help.

I’m at a loss of where to begin here.

New contributor

Rich Kramp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Theme wordpress giá rẻ Theme wordpress giá rẻ Thiết kế website