public final class SQLExpressions extends Object
| Modifier and Type | Field and Description |
|---|---|
static Expression<Object[]> |
all
Wildcard expression
|
static Expression<Long> |
countAll
Wilcard count expression
|
| Modifier and Type | Method and Description |
|---|---|
static <D extends Comparable> |
addDays(DateExpression<D> date,
int days)
Add the given amount of days to the date
|
static <D extends Comparable> |
addDays(DateTimeExpression<D> date,
int days)
Add the given amount of days to the date
|
static <D extends Comparable> |
addHours(DateTimeExpression<D> date,
int hours)
Add the given amount of hours to the date
|
static <D extends Comparable> |
addMinutes(DateTimeExpression<D> date,
int minutes)
Add the given amount of minutes to the date
|
static <D extends Comparable> |
addMonths(DateExpression<D> date,
int months)
Add the given amount of months to the date
|
static <D extends Comparable> |
addMonths(DateTimeExpression<D> date,
int months)
Add the given amount of months to the date
|
static <D extends Comparable> |
addSeconds(DateTimeExpression<D> date,
int seconds)
Add the given amount of seconds to the date
|
static <D extends Comparable> |
addWeeks(DateExpression<D> date,
int weeks)
Add the given amount of weeks to the date
|
static <D extends Comparable> |
addWeeks(DateTimeExpression<D> date,
int weeks)
Add the given amount of weeks to the date
|
static <D extends Comparable> |
addYears(DateExpression<D> date,
int years)
Add the given amount of years to the date
|
static <D extends Comparable> |
addYears(DateTimeExpression<D> date,
int years)
Add the given amount of years to the date
|
static BooleanExpression |
all(BooleanExpression expr)
Get an aggregate all expression for the given boolean expression
|
static BooleanExpression |
any(BooleanExpression expr)
Get an aggregate any expression for the given boolean expression
|
static <T extends Number> |
avg(Expression<T> expr)
Start a window function expression
|
static WindowOver<Double> |
corr(Expression<? extends Number> expr1,
Expression<? extends Number> expr2) |
static WindowOver<Long> |
count()
Start a window function expression
|
static WindowOver<Long> |
count(Expression<?> expr)
Start a window function expression
|
static WindowOver<Long> |
countDistinct(Expression<?> expr)
Start a window function expression
|
static WindowOver<Double> |
covarPop(Expression<? extends Number> expr1,
Expression<? extends Number> expr2) |
static WindowOver<Double> |
covarSamp(Expression<? extends Number> expr1,
Expression<? extends Number> expr2) |
static WindowOver<Double> |
cumeDist() |
static WithinGroup<Double> |
cumeDist(Expression<?>... args) |
static WithinGroup<Double> |
cumeDist(Object... args) |
static <D extends Comparable> |
date(Class<D> type,
DateTimeExpression<?> dateTime)
Convert timestamp to date
|
static <D extends Comparable> |
date(DateTimeExpression<D> dateTime)
Convert timestamp to date
|
static <D extends Comparable> |
dateadd(DatePart unit,
DateExpression<D> date,
int amount)
Get a dateadd(unit, date, amount) expression
|
static <D extends Comparable> |
dateadd(DatePart unit,
DateTimeExpression<D> date,
int amount)
Get a dateadd(unit, date, amount) expression
|
static <D extends Comparable> |
datediff(DatePart unit,
DateExpression<D> start,
D end)
Get a datediff(unit, start, end) expression
|
static <D extends Comparable> |
datediff(DatePart unit,
DateExpression<D> start,
DateExpression<D> end)
Get a datediff(unit, start, end) expression
|
static <D extends Comparable> |
datediff(DatePart unit,
DateTimeExpression<D> start,
D end)
Get a datediff(unit, start, end) expression
|
static <D extends Comparable> |
datediff(DatePart unit,
DateTimeExpression<D> start,
DateTimeExpression<D> end)
Get a datediff(unit, start, end) expression
|
static <D extends Comparable> |
datediff(DatePart unit,
D start,
DateExpression<D> end)
Get a datediff(unit, start, end) expression
|
static <D extends Comparable> |
datediff(DatePart unit,
D start,
DateTimeExpression<D> end)
Get a datediff(unit, start, end) expression
|
static <D extends Comparable> |
datetrunc(DatePart unit,
DateExpression<D> expr)
Truncate the given date expression
|
static <D extends Comparable> |
datetrunc(DatePart unit,
DateTimeExpression<D> expr)
Truncate the given datetime expression
|
static WindowOver<Long> |
denseRank()
rank of the current row without gaps; this function counts peer groups
|
static WithinGroup<Long> |
denseRank(Expression<?>... args) |
static WithinGroup<Long> |
denseRank(Object... args) |
static <T> WindowOver<T> |
firstValue(Expression<T> expr)
returns value evaluated at the row that is the first row of the window frame
|
static <T> WindowOver<T> |
lag(Expression<T> expr)
expr evaluated at the row that is one row before the current row within the partition
|
static <T> WindowOver<T> |
lastValue(Expression<T> expr)
returns value evaluated at the row that is the last row of the window frame
|
static <T> WindowOver<T> |
lead(Expression<T> expr)
expr evaluated at the row that is one row after the current row within the partition;
|
static StringExpression |
left(Expression<String> lhs,
Expression<Integer> rhs)
Get the rhs leftmost characters of lhs
|
static StringExpression |
left(Expression<String> lhs,
int rhs)
Get the rhs leftmost characters of lhs
|
static WithinGroup<Object> |
listagg(Expression<?> expr,
String delimiter) |
static <T extends Comparable> |
max(Expression<T> expr)
Start a window function expression
|
static <T extends Comparable> |
min(Expression<T> expr)
Start a window function expression
|
static <T extends Number> |
nextval(Class<T> type,
String sequence)
Get a nextval(sequence) expression of the given type
|
static SimpleExpression<Long> |
nextval(String sequence)
Get a nextval(sequence) expression
|
static <T> WindowOver<T> |
nthValue(Expression<T> measureExpr,
Expression<? extends Number> n) |
static <T> WindowOver<T> |
nthValue(Expression<T> measureExpr,
Number n) |
static <T extends Number & Comparable> |
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 <T extends Number> |
percentileCont(Expression<T> arg) |
static <T extends Number> |
percentileCont(T arg) |
static <T extends Number> |
percentileDisc(Expression<T> arg) |
static <T extends Number> |
percentileDisc(T arg) |
static WindowOver<Double> |
percentRank() |
static WithinGroup<Double> |
percentRank(Expression<?>... args) |
static WithinGroup<Double> |
percentRank(Object... args) |
static WindowOver<Long> |
rank()
rank of the current row with gaps; same as row_number of its first peer
|
static WithinGroup<Long> |
rank(Expression<?>... args) |
static WithinGroup<Long> |
rank(Object... args) |
static <T> WindowOver<T> |
ratioToReport(Expression<T> expr)
computes the ratio of a value to the sum of a set of values.
|
static WindowOver<Double> |
regrAvgx(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrAvgy(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrCount(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrIntercept(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrR2(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrSlope(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrSxx(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrSxy(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static WindowOver<Double> |
regrSyy(Expression<? extends Number> arg1,
Expression<? extends Number> arg2) |
static StringExpression |
right(Expression<String> lhs,
Expression<Integer> rhs)
Get the rhs leftmost characters of lhs
|
static StringExpression |
right(Expression<String> lhs,
int rhs)
Get the rhs rightmost characters of lhs
|
static WindowOver<Long> |
rowNumber()
number of the current row within its partition, counting from 1
|
static <T extends Number> |
stddev(Expression<T> expr)
returns the sample standard deviation of expr, a set of numbers.
|
static <T extends Number> |
stddevDistinct(Expression<T> expr) |
static <T extends Number> |
stddevPop(Expression<T> expr)
returns the population standard deviation and returns the square root of the population variance.
|
static <T extends Number> |
stddevSamp(Expression<T> expr)
returns the cumulative sample standard deviation and returns the square root of the sample variance.
|
static <T extends Number> |
sum(Expression<T> expr)
Start a window function expression
|
static <T extends Number> |
variance(Expression<T> expr)
returns the variance of expr
|
static <T extends Number> |
varPop(Expression<T> expr)
returns the population variance of a set of numbers after discarding the nulls in this set.
|
static <T extends Number> |
varSamp(Expression<T> expr)
returns the sample variance of a set of numbers after discarding the nulls in this set.
|
public static final Expression<Object[]> all
public static final Expression<Long> countAll
public static BooleanExpression any(BooleanExpression expr)
public static BooleanExpression all(BooleanExpression expr)
public static SimpleExpression<Long> nextval(String sequence)
sequence - public static <T extends Number> SimpleExpression<T> nextval(Class<T> type, String sequence)
type - sequence - public static <D extends Comparable> DateExpression<D> date(DateTimeExpression<D> dateTime)
dateTime - public static <D extends Comparable> DateExpression<D> date(Class<D> type, DateTimeExpression<?> dateTime)
type - dateTime - public static <D extends Comparable> DateTimeExpression<D> dateadd(DatePart unit, DateTimeExpression<D> date, int amount)
unit - date - amount - public static <D extends Comparable> DateExpression<D> dateadd(DatePart unit, DateExpression<D> date, int amount)
unit - date - amount - public static <D extends Comparable> NumberExpression<Integer> datediff(DatePart unit, DateExpression<D> start, DateExpression<D> end)
unit - start - end - public static <D extends Comparable> NumberExpression<Integer> datediff(DatePart unit, D start, DateExpression<D> end)
unit - start - end - public static <D extends Comparable> NumberExpression<Integer> datediff(DatePart unit, DateExpression<D> start, D end)
unit - start - end - public static <D extends Comparable> NumberExpression<Integer> datediff(DatePart unit, DateTimeExpression<D> start, DateTimeExpression<D> end)
unit - start - end - public static <D extends Comparable> NumberExpression<Integer> datediff(DatePart unit, D start, DateTimeExpression<D> end)
unit - start - end - public static <D extends Comparable> NumberExpression<Integer> datediff(DatePart unit, DateTimeExpression<D> start, D end)
unit - start - end - public static <D extends Comparable> DateExpression<D> datetrunc(DatePart unit, DateExpression<D> expr)
unit - expr - public static <D extends Comparable> DateTimeExpression<D> datetrunc(DatePart unit, DateTimeExpression<D> expr)
unit - expr - public static <D extends Comparable> DateTimeExpression<D> addYears(DateTimeExpression<D> date, int years)
date - years - public static <D extends Comparable> DateTimeExpression<D> addMonths(DateTimeExpression<D> date, int months)
date - months - public static <D extends Comparable> DateTimeExpression<D> addWeeks(DateTimeExpression<D> date, int weeks)
date - weeks - public static <D extends Comparable> DateTimeExpression<D> addDays(DateTimeExpression<D> date, int days)
date - days - public static <D extends Comparable> DateTimeExpression<D> addHours(DateTimeExpression<D> date, int hours)
date - hours - public static <D extends Comparable> DateTimeExpression<D> addMinutes(DateTimeExpression<D> date, int minutes)
date - minutes - public static <D extends Comparable> DateTimeExpression<D> addSeconds(DateTimeExpression<D> date, int seconds)
date - seconds - public static <D extends Comparable> DateExpression<D> addYears(DateExpression<D> date, int years)
date - years - public static <D extends Comparable> DateExpression<D> addMonths(DateExpression<D> date, int months)
date - months - public static <D extends Comparable> DateExpression<D> addWeeks(DateExpression<D> date, int weeks)
date - weeks - public static <D extends Comparable> DateExpression<D> addDays(DateExpression<D> date, int days)
date - days - public static <T extends Number> WindowOver<T> sum(Expression<T> expr)
expr - public static WindowOver<Long> count()
public static WindowOver<Long> count(Expression<?> expr)
expr - public static WindowOver<Long> countDistinct(Expression<?> expr)
expr - public static <T extends Number> WindowOver<T> avg(Expression<T> expr)
expr - public static <T extends Comparable> WindowOver<T> min(Expression<T> expr)
expr - public static <T extends Comparable> WindowOver<T> max(Expression<T> expr)
expr - public static <T> WindowOver<T> lead(Expression<T> expr)
expr - public static <T> WindowOver<T> lag(Expression<T> expr)
expr - public static WithinGroup<Object> listagg(Expression<?> expr, String delimiter)
expr - delimiter - public static <T> WindowOver<T> nthValue(Expression<T> measureExpr, Number n)
measureExpr - n - public static <T> WindowOver<T> nthValue(Expression<T> measureExpr, Expression<? extends Number> n)
measureExpr - n - public static <T extends Number & Comparable> WindowOver<T> ntile(T num)
num - public static WindowOver<Long> rank()
public static WithinGroup<Long> rank(Object... args)
args - public static WithinGroup<Long> rank(Expression<?>... args)
args - public static WindowOver<Long> denseRank()
public static WithinGroup<Long> denseRank(Object... args)
args - public static WithinGroup<Long> denseRank(Expression<?>... args)
args - public static WindowOver<Double> percentRank()
public static WithinGroup<Double> percentRank(Object... args)
args - public static WithinGroup<Double> percentRank(Expression<?>... args)
args - public static <T extends Number> WithinGroup<T> percentileCont(T arg)
arg - public static <T extends Number> WithinGroup<T> percentileCont(Expression<T> arg)
arg - public static <T extends Number> WithinGroup<T> percentileDisc(T arg)
arg - public static <T extends Number> WithinGroup<T> percentileDisc(Expression<T> arg)
arg - public static WindowOver<Double> regrSlope(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrIntercept(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrCount(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrR2(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrAvgx(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrAvgy(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrSxx(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrSyy(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> regrSxy(Expression<? extends Number> arg1, Expression<? extends Number> arg2)
arg1 - arg2 - public static WindowOver<Double> cumeDist()
public static WithinGroup<Double> cumeDist(Object... args)
args - public static WithinGroup<Double> cumeDist(Expression<?>... args)
args - public static WindowOver<Double> corr(Expression<? extends Number> expr1, Expression<? extends Number> expr2)
expr1 - expr2 - public static WindowOver<Double> covarPop(Expression<? extends Number> expr1, Expression<? extends Number> expr2)
expr1 - expr2 - public static WindowOver<Double> covarSamp(Expression<? extends Number> expr1, Expression<? extends Number> expr2)
expr1 - expr2 - public static <T> WindowOver<T> ratioToReport(Expression<T> expr)
public static WindowOver<Long> rowNumber()
public static <T extends Number> WindowOver<T> stddev(Expression<T> expr)
expr - public static <T extends Number> WindowOver<T> stddevDistinct(Expression<T> expr)
expr - public static <T extends Number> WindowOver<T> stddevPop(Expression<T> expr)
expr - public static <T extends Number> WindowOver<T> stddevSamp(Expression<T> expr)
expr - public static <T extends Number> WindowOver<T> variance(Expression<T> expr)
expr - public static <T extends Number> WindowOver<T> varPop(Expression<T> expr)
expr - public static <T extends Number> WindowOver<T> varSamp(Expression<T> expr)
expr - public static <T> WindowOver<T> firstValue(Expression<T> expr)
expr - public static <T> WindowOver<T> lastValue(Expression<T> expr)
expr - public static StringExpression left(Expression<String> lhs, int rhs)
lhs - rhs - public static StringExpression right(Expression<String> lhs, int rhs)
lhs - rhs - public static StringExpression left(Expression<String> lhs, Expression<Integer> rhs)
lhs - rhs - public static StringExpression right(Expression<String> lhs, Expression<Integer> rhs)
lhs - rhs - Copyright © 2007–2015 Mysema Ltd. All rights reserved.