| Package | Description |
|---|---|
| com.querydsl.sql |
SQL/JDBC support
|
| Modifier and Type | Method and Description |
|---|---|
static WithinGroup<java.lang.Double> |
SQLExpressions.cumeDist(Expression<?>... args)
As an aggregate function, CUME_DIST calculates, for a hypothetical row r identified by the
arguments of the function and a corresponding sort specification, the relative position of row
r among the rows in the aggregation group.
|
static WithinGroup<java.lang.Double> |
SQLExpressions.cumeDist(java.lang.Object... args)
As an aggregate function, CUME_DIST calculates, for a hypothetical row r identified by the
arguments of the function and a corresponding sort specification, the relative position of row
r among the rows in the aggregation group.
|
static WithinGroup<java.lang.Long> |
SQLExpressions.denseRank(Expression<?>... args)
As an aggregate function, DENSE_RANK calculates the dense rank of a hypothetical row identified
by the arguments of the function with respect to a given sort specification.
|
static WithinGroup<java.lang.Long> |
SQLExpressions.denseRank(java.lang.Object... args)
As an aggregate function, DENSE_RANK calculates the dense rank of a hypothetical row identified
by the arguments of the function with respect to a given sort specification.
|
static WithinGroup<java.lang.Object> |
SQLExpressions.listagg(Expression<?> expr,
java.lang.String delimiter)
LISTAGG orders data within each group specified in the ORDER BY clause and then concatenates
the values of the measure column.
|
static <T extends java.lang.Number> |
SQLExpressions.percentileCont(Expression<T> arg)
Calculates a percentile based on a continuous distribution of the column value
|
static <T extends java.lang.Number> |
SQLExpressions.percentileCont(T arg)
Calculates a percentile based on a continuous distribution of the column value
|
static <T extends java.lang.Number> |
SQLExpressions.percentileDisc(Expression<T> arg)
PERCENTILE_DISC is an inverse distribution function that assumes a discrete distribution model.
|
static <T extends java.lang.Number> |
SQLExpressions.percentileDisc(T arg)
PERCENTILE_DISC is an inverse distribution function that assumes a discrete distribution model.
|
static WithinGroup<java.lang.Double> |
SQLExpressions.percentRank(Expression<?>... args)
As an aggregate function, PERCENT_RANK calculates, for a hypothetical row r identified by the
arguments of the function and a corresponding sort specification, the rank of row r minus 1
divided by the number of rows in the aggregate group.
|
static WithinGroup<java.lang.Double> |
SQLExpressions.percentRank(java.lang.Object... args)
As an aggregate function, PERCENT_RANK calculates, for a hypothetical row r identified by the
arguments of the function and a corresponding sort specification, the rank of row r minus 1
divided by the number of rows in the aggregate group.
|
static WithinGroup<java.lang.Long> |
SQLExpressions.rank(Expression<?>... args)
As an aggregate function, RANK calculates the rank of a hypothetical row identified by the
arguments of the function with respect to a given sort specification.
|
static WithinGroup<java.lang.Long> |
SQLExpressions.rank(java.lang.Object... args)
As an aggregate function, RANK calculates the rank of a hypothetical row identified by the
arguments of the function with respect to a given sort specification.
|
Copyright © 2007–2021 Querydsl. All rights reserved.