select wm_concat([column_name]) over (partition by [column_name])
from table