--假设表名为tbselect ys, count(*)from( select x, to_char(wm_concat(y)) ys from tb group by x ) wgroup by ys;