referring to this question:
I have the following table structure:
id name1 name2 name3 ... 1 Hans Peter Frank 2 Hans Frank Peter 3 Hans Peter Frank 4 Paul Peter Hans . . .
I use the following command to display the duplicates and the counts:
SELECT COUNT(name1), name1, name2, name3 FROM table GROUP BY name1, name2, name3 HAVING (COUNT(name1) > 1) AND (COUNT(name2) > 1) AND (COUNT(name3) > 1)
This command gives me a count of 2. I would like to know how the second line could also be counted as a dublicate.
Unfortunately, the solution to the original question (Finding duplicate values in multiple colums in a SQL table and count) does not work for char