|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface IAverage
Exposes API's to get average value of all non-NULL X within a group. String and BLOB values that do not look like numbers are interpreted as 0. The result of avg() is always a floating point value as long as at there is at least one non-NULL input even if all inputs are integers. The result of avg() is NULL if and only if there are no non-NULL inputs.
Field Summary | |
---|---|
static java.lang.String |
INTERFACE_NAME
|
Method Summary | |
---|---|
IAverageClause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
IAverage |
column(java.lang.String column)
Used to provide name of column for which average will be calculated. |
java.lang.Object |
execute()
Used to get average, this method should be called in last to calculate average. |
IAverage |
groupBy(java.lang.String... columns)
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns. |
IAverageClause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
IAverage |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
IAverageClause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
IAverageClause |
where(java.lang.String column)
Column name of which condition will be specified. |
IAverage |
whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's. |
Field Detail |
---|
static final java.lang.String INTERFACE_NAME
Method Detail |
---|
IAverageClause where(java.lang.String column)
column
- Name of column.
IAverage whereClause(java.lang.String whereClause)
whereClause
- Manually created where clause.
IAverageClause and(java.lang.String column)
column
- Name of column on which condition need to be specified.
IAverageClause or(java.lang.String column)
column
- Name of column on which condition need to be specified.
IAverage groupBy(java.lang.String... columns)
columns
- Name of columns.
IAverageClause having(java.lang.String column)
column
- Name of column on which condition need to be applied.
IAverage havingClause(java.lang.String havingClause)
havingClause
- Where clause.
IAverage column(java.lang.String column)
column
- Name of column.
java.lang.Object execute() throws DatabaseException
DatabaseException
- Throws exception if any error occur while calculating average.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |