org.jooq

Interface GroupConcatOrderByStep

All Superinterfaces:

AggregateFunction<String>, Field<String>, GroupConcatSeparatorStep, GroupField, QueryPart, Serializable, WindowOverStep<String>

public interface GroupConcatOrderByStep
extends GroupConcatSeparatorStep

MySQL's GROUP_CONCAT function.

Author:

Lukas Eder

See Also:

DSL.listAgg(Field)

Method Summary

Methods

Modifier and Type	Method and Description
GroupConcatSeparatorStep	orderBy(Collection<SortField<?>> fields) Add an ORDER BY clause to the query
GroupConcatSeparatorStep	orderBy(Field<?>... fields) Add an ORDER BY clause to the query
GroupConcatSeparatorStep	orderBy(SortField<?>... fields) Add an ORDER BY clause to the query

Methods inherited from interface org.jooq.GroupConcatSeparatorStep

separator

Methods inherited from interface org.jooq.AggregateFunction

keepDenseRankFirstOrderBy, keepDenseRankFirstOrderBy, keepDenseRankFirstOrderBy, keepDenseRankLastOrderBy, keepDenseRankLastOrderBy, keepDenseRankLastOrderBy, over

Methods inherited from interface org.jooq.Field

abs, acos, add, add, as, asc, ascii, asin, atan, atan2, atan2, avg, avgOver, between, between, between, between, betweenSymmetric, betweenSymmetric, betweenSymmetric, betweenSymmetric, bitLength, cast, cast, cast, ceil, charLength, coalesce, coalesce, compare, compare, concat, concat, contains, contains, cos, cosh, cot, coth, count, countDistinct, countOver, decode, decode, decode, decode, deg, desc, div, div, divide, divide, endsWith, endsWith, eq, eq, eq, eq, equal, equal, equal, equal, equalIgnoreCase, equalIgnoreCase, equals, exp, extract, firstValue, floor, ge, ge, ge, ge, getDataType, getDataType, getName, getType, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterOrEqual, greaterThan, greaterThan, greaterThan, greaterThan, greatest, greatest, gt, gt, gt, gt, in, in, in, in, isDistinctFrom, isDistinctFrom, isFalse, isNotDistinctFrom, isNotDistinctFrom, 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, 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, notEqual, notEqual, notEqual, notEqual, notEqualIgnoreCase, notEqualIgnoreCase, notIn, notIn, notIn, notIn, notLike, notLike, notLike, notLike, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeIgnoreCase, notLikeRegex, notLikeRegex, nullif, nullif, nvl, nvl, nvl2, nvl2, octetLength, plus, plus, position, position, pow, power, rad, repeat, repeat, replace, replace, replace, replace, round, round, rpad, rpad, rpad, rpad, rtrim, sign, sin, sinh, sort, sort, sortAsc, sortAsc, sortDesc, sortDesc, sqrt, startsWith, startsWith, stddevPop, stddevPopOver, stddevSamp, stddevSampOver, sub, sub, substring, substring, substring, substring, subtract, subtract, sum, sumOver, tan, tanh, trim, upper, varPop, varPopOver, varSamp, varSampOver

Methods inherited from interface org.jooq.QueryPart

hashCode, toString

Method Detail

orderBy

@Support(value={CUBRID,DB2,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SYBASE})
GroupConcatSeparatorStep orderBy(Field<?>... fields)

Add an ORDER BY clause to the query

orderBy

@Support(value={CUBRID,DB2,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SYBASE})
GroupConcatSeparatorStep orderBy(SortField<?>... fields)

Add an ORDER BY clause to the query

orderBy

@Support(value={CUBRID,DB2,H2,HSQLDB,MYSQL,ORACLE,POSTGRES,SYBASE})
GroupConcatSeparatorStep orderBy(Collection<SortField<?>> fields)

Add an ORDER BY clause to the query