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

]