# groupConcat

fun <T : String?> Expression<T>.groupConcat(separator: String? = null, distinct: Boolean = false, orderBy: Pair<Expression<*>, SortOrder>): GroupConcat<T>
fun <T : String?> Expression<T>.groupConcat(separator: String? = null, distinct: Boolean = false, orderBy: Array<Pair<Expression<*>, SortOrder>> = emptyArray()): GroupConcat<T>

Concatenates all non-null input values of each group from this string expression, separated by separator.

#### Parameters

separator

The separator to use between concatenated values. If left `null`, the database default will be used.

distinct

If set to `true`, duplicate values will be eliminated.

orderBy

If specified, values will be sorted in the concatenated string.

#### Samples

org.jetbrains.exposed.sql.tests.shared.dml.GroupByTests.testGroupConcat