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.