GROUP_CONCAT


]Podporované v MY_SQL 

Syntax

GROUP_CONCAT( [DISTINCT] expr [,expr ...]
[ORDER BY <unsigned_integer | col_name | expr>
[ASC | DESC] [,col_name ...] ]
[SEPARATOR str_val])


Popis

Príkaz jazyka SQL
This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values.

Príklad

SELECT student_name, GROUP_CONCAT(test_score) FROM student GROUP BY student_name;


SELECT student_name, GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ) FROM student GROUP BY student_name;


Pozri aj

group_concat_max_len

]