Package | Description |
---|---|
com.querydsl.sql |
SQL/JDBC support
|
Modifier and Type | Method and Description |
---|---|
static WithinGroup<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<Double> |
SQLExpressions.cumeDist(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<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<Long> |
SQLExpressions.denseRank(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<Object> |
SQLExpressions.listagg(Expression<?> expr,
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 Number> |
SQLExpressions.percentileCont(Expression<T> arg)
Calculates a percentile based on a continuous distribution of the column value
|
static <T extends Number> |
SQLExpressions.percentileCont(T arg)
Calculates a percentile based on a continuous distribution of the column value
|
static <T extends Number> |
SQLExpressions.percentileDisc(Expression<T> arg)
PERCENTILE_DISC is an inverse distribution function that assumes a discrete distribution model.
|
static <T extends Number> |
SQLExpressions.percentileDisc(T arg)
PERCENTILE_DISC is an inverse distribution function that assumes a discrete distribution model.
|
static WithinGroup<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<Double> |
SQLExpressions.percentRank(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<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<Long> |
SQLExpressions.rank(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–2016 Querydsl. All rights reserved.