Interface WindowExcludeStep<T>

Type Parameters:

T - The function return type

All Superinterfaces:

Field<T>, FieldOrConstraint, FieldOrRow, FieldOrRowOrSelect, GroupField, Named, OrderField<T>, QueryPart, SelectField<T>, SelectFieldOrAsterisk, Serializable, TableElement, Typed<T>, WindowFinalStep<T>

public interface WindowExcludeStep<T>
extends WindowFinalStep<T>

This type is used for the window function DSL API.

Example:

field.firstValue()
     .ignoreNulls()
     .over()
     .partitionBy(AUTHOR_ID)
     .orderBy(PUBLISHED_IN.asc())
     .rowsBetweenUnboundedPreceding()
     .andUnboundedFollowing()

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull WindowFinalStep<T>	excludeCurrentRow()	Add an EXCLUDE CURRENT ROW clause.
@NotNull WindowFinalStep<T>	excludeGroup()	Add an EXCLUDE GROUP clause.
@NotNull WindowFinalStep<T>	excludeNoOthers()	Add an EXCLUDE NO OTHERS clause.
@NotNull WindowFinalStep<T>	excludeTies()	Add an EXCLUDE TIES clause.

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 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

Method Details

excludeCurrentRow

@NotNull
@Support({COCKROACHDB,DUCKDB,EXASOL,H2,ORACLE20C,POSTGRES_11,SQLITE_3_28,TRINO,YUGABYTEDB})
@NotNull WindowFinalStep<T> excludeCurrentRow()

Add an EXCLUDE CURRENT ROW clause.

excludeGroup

@NotNull
@Support({COCKROACHDB,DUCKDB,EXASOL,H2,ORACLE20C,POSTGRES_11,SQLITE_3_28,TRINO,YUGABYTEDB})
@NotNull WindowFinalStep<T> excludeGroup()

Add an EXCLUDE GROUP clause.

excludeTies

@NotNull
@Support({COCKROACHDB,DUCKDB,EXASOL,H2,ORACLE20C,POSTGRES_11,SQLITE_3_28,TRINO,YUGABYTEDB})
@NotNull WindowFinalStep<T> excludeTies()

Add an EXCLUDE TIES clause.

excludeNoOthers

@NotNull
@Support({AURORA_POSTGRES,BIGQUERY,COCKROACHDB,DB2,DUCKDB,EXASOL,H2,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER2012,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB})
@NotNull WindowFinalStep<T> excludeNoOthers()

Add an EXCLUDE NO OTHERS clause.