Produced by Siminov Software Solution LLP

siminov.orm.database.impl
Interface IMax

All Known Implementing Classes:
Select

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

INTERFACE_NAME

static final java.lang.String INTERFACE_NAME
Method Detail

where

IMaxClause where(java.lang.String column)
Column name of which condition will be specified.

Parameters:
column - Name of column.
Returns:
IMaxClause Interface.

whereClause

IMax whereClause(java.lang.String whereClause)
Used to provide manually created Where clause, instead of using API's.

Parameters:
whereClause - Manually created where clause.
Returns:
IMax Interface.

and

IMaxClause and(java.lang.String column)
Used to specify AND condition between where clause.

Parameters:
column - Name of column on which condition need to be specified.
Returns:
IMaxClause Interface.

or

IMaxClause or(java.lang.String column)
Used to specify OR condition between where clause.

Parameters:
column - Name of column on which condition need to be specified.
Returns:
IMaxClause Interface.

groupBy

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.

Parameters:
columns - Name of columns.
Returns:
IMax Interface.

having

IMaxClause having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.

Parameters:
column - Name of column on which condition need to be applied.
Returns:
IMaxClause Interface.

havingClause

IMax havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's.

Parameters:
havingClause - Where clause.
Returns:
IMax Interface.

column

IMax column(java.lang.String column)
Used to provide name of column for which maximum will be calculated.

Parameters:
column - Name of column.
Returns:
IMax Interface.

execute

java.lang.Object execute()
                         throws DatabaseException
Used to get maximum, this method should be called in last to calculate maximum.

Returns:
Return maximum.
Throws:
DatabaseException - Throws exception if any error occur while calculating maximum.

Apache License 2.0

Copyright 2013