|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface IMax
Exposes API's to returns the maximum value of all values in the group. The maximum value is the value that would be returned last in an ORDER BY on the same column. Aggregate max() returns NULL if and only if there are no non-NULL values in the group.
Field Summary | |
---|---|
static java.lang.String |
INTERFACE_NAME
|
Method Summary | |
---|---|
IMaxClause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
IMax |
column(java.lang.String column)
Used to provide name of column for which maximum will be calculated. |
java.lang.Object |
execute()
Used to get maximum, this method should be called in last to calculate maximum. |
IMax |
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. |
IMaxClause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
IMax |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
IMaxClause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
IMaxClause |
where(java.lang.String column)
Column name of which condition will be specified. |
IMax |
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 |
---|
IMaxClause where(java.lang.String column)
column
- Name of column.
IMax whereClause(java.lang.String whereClause)
whereClause
- Manually created where clause.
IMaxClause and(java.lang.String column)
column
- Name of column on which condition need to be specified.
IMaxClause or(java.lang.String column)
column
- Name of column on which condition need to be specified.
IMax groupBy(java.lang.String... columns)
columns
- Name of columns.
IMaxClause having(java.lang.String column)
column
- Name of column on which condition need to be applied.
IMax havingClause(java.lang.String havingClause)
havingClause
- Where clause.
IMax column(java.lang.String column)
column
- Name of column.
java.lang.Object execute() throws DatabaseException
DatabaseException
- Throws exception if any error occur while calculating maximum.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |