Package org.jooq

Interface GroupConcatOrderByStep

All Superinterfaces:

AggregateFilterStep<java.lang.String>, AggregateFunction<java.lang.String>, Field<java.lang.String>, FieldOrConstraint, FieldOrRow, GroupConcatSeparatorStep, GroupField, Named, OrderField<java.lang.String>, QueryPart, SelectField<java.lang.String>, SelectFieldOrAsterisk, java.io.Serializable, WindowBeforeOverStep<java.lang.String>, WindowOverStep<java.lang.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
GroupConcatSeparatorStep	orderBy(java.util.Collection<? extends OrderField<?>> fields)	Add an ORDER BY clause to the function.
GroupConcatSeparatorStep	orderBy(OrderField<?>... fields)	Add an ORDER BY clause to the function.

Methods inherited from interface org.jooq.AggregateFilterStep

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

Methods inherited from interface org.jooq.AggregateFunction

keepDenseRankFirstOrderBy, keepDenseRankFirstOrderBy, keepDenseRankLastOrderBy, keepDenseRankLastOrderBy

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, as, as, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitAnd, bitAnd, bitLength, bitNand, bitNand, bitNor, bitNor, bitNot, bitOr, bitOr, bitXNor, bitXNor, bitXor, bitXor, cast, cast, cast, ceil, changed, charLength, coalesce, coalesce, coerce, coerce, coerce, collate, collate, collate, compare, compare, compare, compare, concat, concat, concat, contains, contains, containsIgnoreCase, containsIgnoreCase, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, endsWithIgnoreCase, endsWithIgnoreCase, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, field, firstValue, floor, from, ge, ge, ge, ge, get, getBinding, getComment, getConverter, getDataType, getDataType, getName, getType, getValue, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isJson, isNotDistinctFrom, isNotDistinctFrom, isNotJson, isNotNull, isNull, isTrue, lag, lag, lag, lag, lastValue, le, le, le, le, lead, lead, lead, lead, least, least, length, lessOrEqual, lessOrEqual, lessOrEqual, lessOrEqual, lessThan, lessThan, lessThan, lessThan, like, like, like, like, like, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeIgnoreCase, likeRegex, likeRegex, ln, log, lower, lpad, lpad, lpad, lpad, lt, lt, lt, lt, ltrim, max, maxOver, median, min, minOver, minus, minus, mod, mod, modulo, modulo, mul, mul, multiply, multiply, ne, ne, ne, ne, neg, notBetween, notBetween, notBetween, notBetween, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, notBetweenSymmetric, 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, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, original, plus, plus, plus, position, position, pow, pow, power, power, rad, rem, rem, repeat, repeat, replace, replace, replace, replace, reset, round, round, rpad, rpad, rpad, rpad, rtrim, shl, shl, shr, shr, sign, similarTo, similarTo, similarTo, similarTo, sin, sinh, sort, sort, sortAsc, sortAsc, sortDefault, sortDesc, sortDesc, sqrt, startsWith, startsWith, startsWithIgnoreCase, startsWithIgnoreCase, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, times, times, trim, unaryMinus, unaryPlus, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.GroupConcatSeparatorStep

separator

Methods inherited from interface org.jooq.Named

getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Methods inherited from interface org.jooq.WindowOverStep

over, over, over, over, over

Method Detail

orderBy

@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,MARIADB,MYSQL,ORACLE11G,POSTGRES,SYBASE})
GroupConcatSeparatorStep orderBy(OrderField<?>... fields)

Add an ORDER BY clause to the function.

orderBy

@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,H2,HSQLDB,MARIADB,MYSQL,ORACLE11G,POSTGRES,SYBASE})
GroupConcatSeparatorStep orderBy(java.util.Collection<? extends OrderField<?>> fields)

Add an ORDER BY clause to the function.