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.