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