使用将三列合并为一列，
Union all然后在外部查询中找到每个组的计数。试试这个。
SELECt value, Count(value)FROM (SELECt value AS value FROM test2 UNIOn ALL SELECt value2 FROM test2 UNIOn ALL SELECt value3 FROM test2)aGROUP BY value
使用将三列合并为一列，
Union all然后在外部查询中找到每个组的计数。试试这个。
SELECt value, Count(value)FROM (SELECt value AS value FROM test2 UNIOn ALL SELECt value2 FROM test2 UNIOn ALL SELECt value3 FROM test2)aGROUP BY value
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
