If you want to google to understand better, it's the same idea as

WM_CONCAT

in Oracle, or

GROUP_CONCAT

in mySQL