select wm_concat([column_name]) over (partition by [column_name]) from table Written by Knilluz on 23 June 2010 at 08:45