Uses of Class
com.mysema.query.sql.WindowOver

Packages that use WindowOver

Package	Description
com.mysema.query.sql	SQL/JDBC support for Querydsl

Uses of WindowOver in com.mysema.query.sql

Methods in com.mysema.query.sql that return WindowOver

Modifier and Type	Method and Description
static <T extends Number> WindowOver<T>	SQLExpressions.avg(Expression<T> expr) Start a window function expression
static WindowOver<Double>	SQLExpressions.corr(Expression<? extends Number> expr1, Expression<? extends Number> expr2)
static WindowOver<Long>	SQLExpressions.count() Start a window function expression
static WindowOver<Long>	SQLExpressions.count(Expression<?> expr) Start a window function expression
static WindowOver<Long>	SQLExpressions.countDistinct(Expression<?> expr) Start a window function expression
static WindowOver<Double>	SQLExpressions.covarPop(Expression<? extends Number> expr1, Expression<? extends Number> expr2)
static WindowOver<Double>	SQLExpressions.covarSamp(Expression<? extends Number> expr1, Expression<? extends Number> expr2)
static WindowOver<Double>	SQLExpressions.cumeDist()
static WindowOver<Long>	SQLExpressions.denseRank() rank of the current row without gaps; this function counts peer groups
static <T> WindowOver<T>	SQLExpressions.firstValue(Expression<T> expr) returns value evaluated at the row that is the first row of the window frame
static <T> WindowOver<T>	SQLExpressions.lag(Expression<T> expr) expr evaluated at the row that is one row before the current row within the partition
static <T> WindowOver<T>	SQLExpressions.lastValue(Expression<T> expr) returns value evaluated at the row that is the last row of the window frame
static <T> WindowOver<T>	SQLExpressions.lead(Expression<T> expr) expr evaluated at the row that is one row after the current row within the partition;
static <T extends Comparable> WindowOver<T>	SQLExpressions.max(Expression<T> expr) Start a window function expression
static <T extends Comparable> WindowOver<T>	SQLExpressions.min(Expression<T> expr) Start a window function expression
static <T> WindowOver<T>	SQLExpressions.nthValue(Expression<T> measureExpr, Expression<? extends Number> n)
static <T> WindowOver<T>	SQLExpressions.nthValue(Expression<T> measureExpr, Number n)
static <T extends Number & Comparable> WindowOver<T>	SQLExpressions.ntile(T num) divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each row
static WindowOver<Double>	SQLExpressions.percentRank()
static WindowOver<Long>	SQLExpressions.rank() rank of the current row with gaps; same as row_number of its first peer
static <T> WindowOver<T>	SQLExpressions.ratioToReport(Expression<T> expr) computes the ratio of a value to the sum of a set of values.
static WindowOver<Double>	SQLExpressions.regrAvgx(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrAvgy(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrCount(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrIntercept(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrR2(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrSlope(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrSxx(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrSxy(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Double>	SQLExpressions.regrSyy(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
static WindowOver<Long>	SQLExpressions.rowNumber() number of the current row within its partition, counting from 1
static <T extends Number> WindowOver<T>	SQLExpressions.stddev(Expression<T> expr) returns the sample standard deviation of expr, a set of numbers.
static <T extends Number> WindowOver<T>	SQLExpressions.stddevDistinct(Expression<T> expr)
static <T extends Number> WindowOver<T>	SQLExpressions.stddevPop(Expression<T> expr) returns the population standard deviation and returns the square root of the population variance.
static <T extends Number> WindowOver<T>	SQLExpressions.stddevSamp(Expression<T> expr) returns the cumulative sample standard deviation and returns the square root of the sample variance.
static <T extends Number> WindowOver<T>	SQLExpressions.sum(Expression<T> expr) Start a window function expression
static <T extends Number> WindowOver<T>	SQLExpressions.variance(Expression<T> expr) returns the variance of expr
static <T extends Number> WindowOver<T>	SQLExpressions.varPop(Expression<T> expr) returns the population variance of a set of numbers after discarding the nulls in this set.
static <T extends Number> WindowOver<T>	SQLExpressions.varSamp(Expression<T> expr) returns the sample variance of a set of numbers after discarding the nulls in this set.

Constructors in com.mysema.query.sql with parameters of type WindowOver

Constructor and Description
WindowFirstLast(WindowOver<T> target, boolean first)