Category "conditional-aggregation"

Finding duplicate values in multiple colums in a SQL table and count for chars

referring to this question: Finding duplicate values in multiple colums in a SQL table and count I have the following table structure: id name1 name2 name3 ...