You need to group the result, and then if you do

NS_CONCAT({field})

the result will be the value of each {field} in the group seperated by commas