|
2.17.2: 2011-06-17 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object net.sf.basedb.core.query.Aggregations
public class Aggregations
A factory class to create aggregate expressions.
Constructor Summary | |
---|---|
Aggregations()
|
Method Summary | |
---|---|
static Expression |
count(Expression e,
boolean distinct)
Calculates the number of values for an expression: new expression = COUNT(e) |
static Expression |
geometricMean(Expression e)
Calculates the geometric mean of all values for an expression: new expression = EXP(AVG(LN(e))). |
static Expression |
max(Expression e)
Calculates the maximum value of an expression: new expression = MAX(e) |
static Expression |
mean(Expression e)
Calculates the arithmetic mean of all values for an expression: new expression = AVG(e) |
static Expression |
min(Expression e)
Calculates the minimum value of an expression: new expression = MIN(e) |
static Expression |
quadraticMean(Expression e)
Calculates the quadratic mean, also called Root Mean Square, for an expression: new expression = sqrt(AVG(e*e)) |
static Expression |
sum(Expression e)
Calculates the sum of all values of an expression: new expression = SUM(e) |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public Aggregations()
Method Detail |
---|
public static Expression count(Expression e, boolean distinct)
e
- The expression to count, or null to count all rows (ie. COUNT(*))distinct
- If only distinct values should be counted
public static Expression geometricMean(Expression e) throws InvalidDataException
e
- The expression to use in the calculation
InvalidDataException
- If the expression is nullpublic static Expression max(Expression e) throws InvalidDataException
e
- The expression to use in the calculation
InvalidDataException
- If the expression is nullpublic static Expression min(Expression e) throws InvalidDataException
e
- The expression to use in the calculation
InvalidDataException
- If the expression is nullpublic static Expression mean(Expression e) throws InvalidDataException
e
- The expression to use in the calculation
InvalidDataException
- If the expression is nullpublic static Expression sum(Expression e) throws InvalidDataException
e
- The expression to use in the calculation
InvalidDataException
- If the expression is nullpublic static Expression quadraticMean(Expression e)
e
- The expression to use in the calculation
InvalidUseOfNullException
- If the expression is null
|
2.17.2: 2011-06-17 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |