jOOQ 3.18.7 · org.jooq.WindowRowsStep

Method Summary

Modifier and Type	Method and Description
public @NotNull WindowRowsAndStep<T>	groupsBetweenCurrentRow() Add a `GROUPS BETWEEN CURRENT ROW …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	groupsBetweenFollowing(int number) Add a `GROUPS BETWEEN [number] FOLLOWING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	groupsBetweenPreceding(int number) Add a `GROUPS BETWEEN [number] PRECEDING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	groupsBetweenUnboundedFollowing() Add a `GROUPS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	groupsBetweenUnboundedPreceding() Add a `GROUPS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	groupsCurrentRow() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS CURRENT ROW` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	groupsFollowing(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS [number] FOLLOWING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	groupsPreceding(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS [number] PRECEDING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	groupsUnboundedFollowing() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS UNBOUNDED FOLLOWING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	groupsUnboundedPreceding() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `GROUPS UNBOUNDED PRECEDING` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rangeBetweenCurrentRow() Add a `RANGE BETWEEN CURRENT ROW …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rangeBetweenFollowing(int number) Add a `RANGE BETWEEN [number] FOLLOWING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rangeBetweenPreceding(int number) Add a `RANGE BETWEEN [number] PRECEDING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rangeBetweenUnboundedFollowing() Add a `RANGE BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rangeBetweenUnboundedPreceding() Add a `RANGE BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rangeCurrentRow() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE CURRENT ROW` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rangeFollowing(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE [number] FOLLOWING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rangePreceding(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE [number] PRECEDING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rangeUnboundedFollowing() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE UNBOUNDED FOLLOWING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rangeUnboundedPreceding() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `RANGE UNBOUNDED PRECEDING` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rowsBetweenCurrentRow() Add a `ROWS BETWEEN CURRENT ROW …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rowsBetweenFollowing(int number) Add a `ROWS BETWEEN [number] FOLLOWING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rowsBetweenPreceding(int number) Add a `ROWS BETWEEN [number] PRECEDING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rowsBetweenUnboundedFollowing() Add a `ROWS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function.
public @NotNull WindowRowsAndStep<T>	rowsBetweenUnboundedPreceding() Add a `ROWS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rowsCurrentRow() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS CURRENT ROW` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rowsFollowing(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS [number] FOLLOWING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rowsPreceding(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS [number] PRECEDING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rowsUnboundedFollowing() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS UNBOUNDED FOLLOWING` frame clause to the window function.
public @NotNull WindowExcludeStep<T>	rowsUnboundedPreceding() Deprecated as a consequence of `WindowExcludeStep` being deprecated. Add a `ROWS UNBOUNDED PRECEDING` frame clause to the window function.

Method Detail

groupsBetweenCurrentRow back to summary

groupsBetweenCurrentRow	back to summary
public @NotNull WindowRowsAndStep<T> groupsBetweenCurrentRow() Add a `GROUPS BETWEEN CURRENT ROW …` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> groupsBetweenCurrentRow()

Add a GROUPS BETWEEN CURRENT ROW … frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsBetweenFollowing back to summary

groupsBetweenFollowing	back to summary
public @NotNull WindowRowsAndStep<T> groupsBetweenFollowing(int number) Add a `GROUPS BETWEEN [number] FOLLOWING …` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> groupsBetweenFollowing(int number)

Add a GROUPS BETWEEN [number] FOLLOWING … frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsBetweenPreceding back to summary

groupsBetweenPreceding	back to summary
public @NotNull WindowRowsAndStep<T> groupsBetweenPreceding(int number) Add a `GROUPS BETWEEN [number] PRECEDING …` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> groupsBetweenPreceding(int number)

Add a GROUPS BETWEEN [number] PRECEDING … frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsBetweenUnboundedFollowing back to summary

groupsBetweenUnboundedFollowing	back to summary
public @NotNull WindowRowsAndStep<T> groupsBetweenUnboundedFollowing() Add a `GROUPS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> groupsBetweenUnboundedFollowing()

Add a GROUPS BETWEEN UNBOUNDED FOLLOWING … frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsBetweenUnboundedPreceding back to summary

groupsBetweenUnboundedPreceding	back to summary
public @NotNull WindowRowsAndStep<T> groupsBetweenUnboundedPreceding() Add a `GROUPS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> groupsBetweenUnboundedPreceding()

Add a GROUPS BETWEEN UNBOUNDED PRECEDING … frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsCurrentRow back to summary

groupsCurrentRow	back to summary
public @NotNull WindowExcludeStep<T> groupsCurrentRow() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS CURRENT ROW` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> groupsCurrentRow()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a GROUPS CURRENT ROW frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsFollowing back to summary

groupsFollowing	back to summary
public @NotNull WindowExcludeStep<T> groupsFollowing(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS [number] FOLLOWING` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> groupsFollowing(int number)

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a GROUPS [number] FOLLOWING frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsPreceding back to summary

groupsPreceding	back to summary
public @NotNull WindowExcludeStep<T> groupsPreceding(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS [number] PRECEDING` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> groupsPreceding(int number)

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a GROUPS [number] PRECEDING frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsUnboundedFollowing back to summary

groupsUnboundedFollowing	back to summary
public @NotNull WindowExcludeStep<T> groupsUnboundedFollowing() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS UNBOUNDED FOLLOWING` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> groupsUnboundedFollowing()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a GROUPS UNBOUNDED FOLLOWING frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

groupsUnboundedPreceding back to summary

groupsUnboundedPreceding	back to summary
public @NotNull WindowExcludeStep<T> groupsUnboundedPreceding() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `GROUPS UNBOUNDED PRECEDING` frame clause to the window function. Annotations @NotNull @Support:H2, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> groupsUnboundedPreceding()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a GROUPS UNBOUNDED PRECEDING frame clause to the window function.

Annotations

@NotNull
@Support:H2, POSTGRES, SQLITE, YUGABYTEDB

rangeBetweenCurrentRow back to summary

rangeBetweenCurrentRow	back to summary
public @NotNull WindowRowsAndStep<T> rangeBetweenCurrentRow() Add a `RANGE BETWEEN CURRENT ROW …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rangeBetweenCurrentRow()

Add a RANGE BETWEEN CURRENT ROW … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeBetweenFollowing back to summary

rangeBetweenFollowing	back to summary
public @NotNull WindowRowsAndStep<T> rangeBetweenFollowing(int number) Add a `RANGE BETWEEN [number] FOLLOWING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rangeBetweenFollowing(int number)

Add a RANGE BETWEEN [number] FOLLOWING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeBetweenPreceding back to summary

rangeBetweenPreceding	back to summary
public @NotNull WindowRowsAndStep<T> rangeBetweenPreceding(int number) Add a `RANGE BETWEEN [number] PRECEDING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rangeBetweenPreceding(int number)

Add a RANGE BETWEEN [number] PRECEDING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeBetweenUnboundedFollowing back to summary

rangeBetweenUnboundedFollowing	back to summary
public @NotNull WindowRowsAndStep<T> rangeBetweenUnboundedFollowing() Add a `RANGE BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rangeBetweenUnboundedFollowing()

Add a RANGE BETWEEN UNBOUNDED FOLLOWING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeBetweenUnboundedPreceding back to summary

rangeBetweenUnboundedPreceding	back to summary
public @NotNull WindowRowsAndStep<T> rangeBetweenUnboundedPreceding() Add a `RANGE BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rangeBetweenUnboundedPreceding()

Add a RANGE BETWEEN UNBOUNDED PRECEDING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeCurrentRow back to summary

rangeCurrentRow	back to summary
public @NotNull WindowExcludeStep<T> rangeCurrentRow() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `RANGE CURRENT ROW` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rangeCurrentRow()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a RANGE CURRENT ROW frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeFollowing back to summary

rangeFollowing	back to summary
public @NotNull WindowExcludeStep<T> rangeFollowing(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `RANGE [number] FOLLOWING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rangeFollowing(int number)

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a RANGE [number] FOLLOWING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangePreceding back to summary

rangePreceding	back to summary
public @NotNull WindowExcludeStep<T> rangePreceding(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `RANGE [number] PRECEDING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rangePreceding(int number)

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a RANGE [number] PRECEDING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeUnboundedFollowing back to summary

rangeUnboundedFollowing	back to summary
public @NotNull WindowExcludeStep<T> rangeUnboundedFollowing() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `RANGE UNBOUNDED FOLLOWING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rangeUnboundedFollowing()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a RANGE UNBOUNDED FOLLOWING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rangeUnboundedPreceding back to summary

rangeUnboundedPreceding	back to summary
public @NotNull WindowExcludeStep<T> rangeUnboundedPreceding() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `RANGE UNBOUNDED PRECEDING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rangeUnboundedPreceding()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a RANGE UNBOUNDED PRECEDING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsBetweenCurrentRow back to summary

rowsBetweenCurrentRow	back to summary
public @NotNull WindowRowsAndStep<T> rowsBetweenCurrentRow() Add a `ROWS BETWEEN CURRENT ROW …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rowsBetweenCurrentRow()

Add a ROWS BETWEEN CURRENT ROW … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsBetweenFollowing back to summary

rowsBetweenFollowing	back to summary
public @NotNull WindowRowsAndStep<T> rowsBetweenFollowing(int number) Add a `ROWS BETWEEN [number] FOLLOWING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rowsBetweenFollowing(int number)

Add a ROWS BETWEEN [number] FOLLOWING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsBetweenPreceding back to summary

rowsBetweenPreceding	back to summary
public @NotNull WindowRowsAndStep<T> rowsBetweenPreceding(int number) Add a `ROWS BETWEEN [number] PRECEDING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rowsBetweenPreceding(int number)

Add a ROWS BETWEEN [number] PRECEDING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsBetweenUnboundedFollowing back to summary

rowsBetweenUnboundedFollowing	back to summary
public @NotNull WindowRowsAndStep<T> rowsBetweenUnboundedFollowing() Add a `ROWS BETWEEN UNBOUNDED FOLLOWING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rowsBetweenUnboundedFollowing()

Add a ROWS BETWEEN UNBOUNDED FOLLOWING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsBetweenUnboundedPreceding back to summary

rowsBetweenUnboundedPreceding	back to summary
public @NotNull WindowRowsAndStep<T> rowsBetweenUnboundedPreceding() Add a `ROWS BETWEEN UNBOUNDED PRECEDING …` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowRowsAndStep<T> rowsBetweenUnboundedPreceding()

Add a ROWS BETWEEN UNBOUNDED PRECEDING … frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsCurrentRow back to summary

rowsCurrentRow	back to summary
public @NotNull WindowExcludeStep<T> rowsCurrentRow() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `ROWS CURRENT ROW` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rowsCurrentRow()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a ROWS CURRENT ROW frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsFollowing back to summary

rowsFollowing	back to summary
public @NotNull WindowExcludeStep<T> rowsFollowing(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `ROWS [number] FOLLOWING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rowsFollowing(int number)

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a ROWS [number] FOLLOWING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsPreceding back to summary

rowsPreceding	back to summary
public @NotNull WindowExcludeStep<T> rowsPreceding(int number) Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `ROWS [number] PRECEDING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rowsPreceding(int number)

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a ROWS [number] PRECEDING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsUnboundedFollowing back to summary

rowsUnboundedFollowing	back to summary
public @NotNull WindowExcludeStep<T> rowsUnboundedFollowing() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `ROWS UNBOUNDED FOLLOWING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rowsUnboundedFollowing()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a ROWS UNBOUNDED FOLLOWING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

rowsUnboundedPreceding back to summary

rowsUnboundedPreceding	back to summary
public @NotNull WindowExcludeStep<T> rowsUnboundedPreceding() Deprecated as a consequence of `WindowExcludeStep` being deprecated. See corresponding docs for further information. Add a `ROWS UNBOUNDED PRECEDING` frame clause to the window function. Annotations @NotNull @Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public @NotNull WindowExcludeStep<T> rowsUnboundedPreceding()

Deprecated

as a consequence of WindowExcludeStep being deprecated. See corresponding docs for further information.

Add a ROWS UNBOUNDED PRECEDING frame clause to the window function.

Annotations

@NotNull
@Support:FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB

public Interface WindowRowsStep<T>

Method Summary

Method Detail