'How to count the words in a column and group them together in SQL Server

I am struggling to find a way to split the words within a column in a column into multiple rows and count the occurrences.

Looking for some advice on possible ways to achieve requirement.

Table:

enter image description here

Internally I wanted to split the words into multiple rows:

enter image description here

Then finally group them to count the duplicates:

enter image description here

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions