Interface GroupConcatOrderByStep

All Superinterfaces:

AggregateFilterStep<String>, AggregateFunction<String>, Field<String>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupConcatSeparatorStep, GroupField, Named, OrderField<String>, QueryPart, SelectField<String>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<String>, WindowBeforeOverStep<String>, WindowOverStep<String>

public interface GroupConcatOrderByStep
extends GroupConcatSeparatorStep

MySQL's GROUP_CONCAT function.

Author:

Lukas Eder

See Also:

• DSL.listAgg(Field)

Method Summary

Modifier and Type	Method	Description
@NotNull GroupConcatSeparatorStep	orderBy(Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
@NotNull GroupConcatSeparatorStep	orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.

Methods inherited from interface AggregateFilterStep

filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere, filterWhere

Methods inherited from interface AggregateFunction

$filterWhere, keepDenseRankFirstOrderBy, keepDenseRankFirstOrderBy, keepDenseRankLastOrderBy, keepDenseRankLastOrderBy

Methods inherited from interface Field

add, add, as, as, as, as, asc, ascii, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, binaryLike, binaryLike, binaryLike, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, comment, comment, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, convert, convert, convert, convertFrom, convertFrom, convertTo, convertTo, decode, decode, decode, decode, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, field, from, ge, ge, ge, ge, get, getComment, getName, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isDistinctFrom, isDocument, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotDistinctFrom, isNotDocument, isNotJson, isNotNull, isNull, isTrue, le, le, le, le, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBinaryLike, notBinaryLike, notBinaryLike, notContains, notContains, notContainsIgnoreCase, notContainsIgnoreCase, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, notSimilarTo, nullif, nullif, nullsFirst, nullsLast, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, similarTo, similarTo, similarTo, similarTo, similarTo, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, sub, sub, substring, substring, substring, substring, subtract, subtract, times, times, touched, trim, unaryMinus, unaryPlus, upper

Methods inherited from interface GroupConcatSeparatorStep

separator, separator

Methods inherited from interface Named

$name, getCommentPart, getQualifiedName, getUnqualifiedName

Methods inherited from interface QueryPart

$replace, $replace, $traverse, $traverse, hashCode, toString

Methods inherited from interface Typed

$dataType, getBinding, getConverter, getDataType, getDataType, getType

Methods inherited from interface WindowOverStep

over, over, over, over, over

Method Details

orderBy

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,H2,HANA,HSQLDB,MARIADB,MYSQL,ORACLE11G,POSTGRES,SPANNER,SYBASE,TERADATA})
@NotNull GroupConcatSeparatorStep orderBy(OrderField<?>... fields)

Add an ORDER BY clause to the function.

orderBy

@NotNull
@Support({AURORA_MYSQL,AURORA_POSTGRES,BIGQUERY,COCKROACHDB,CUBRID,DB2,DUCKDB,EXASOL,H2,HANA,HSQLDB,MARIADB,MYSQL,ORACLE11G,POSTGRES,SPANNER,SYBASE,TERADATA})
@NotNull GroupConcatSeparatorStep orderBy(Collection<? extends OrderField<?>> fields)

Add an ORDER BY clause to the function.