Produced by Siminov Software Solution LLP

siminov.orm.database.impl
Interface IMin

All Known Implementing Classes:
Select

public interface IMin

Exposes API's to returns the minimum non-NULL value of all values in the group. The minimum value is the first non-NULL value that would appear in an ORDER BY of the column. Aggregate min() 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
 IMinClause and(java.lang.String column)
          Used to specify AND condition between where clause.
 IMin column(java.lang.String column)
          Used to provide name of column for which max will be calculated.
 java.lang.Object execute()
          Used to get minimum, this method should be called in last to calculate minimum.
 IMin 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.
 IMinClause having(java.lang.String column)
          Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
 IMin havingClause(java.lang.String havingClause)
          Used to provide manually created Where clause, instead of using API's.
 IMinClause or(java.lang.String column)
          Used to specify OR condition between where clause.
 IMinClause where(java.lang.String column)
          Column name of which condition will be specified.
 IMin 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

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

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

whereClause

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

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

and

IMinClause 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:
IMinClause Interface.

or

IMinClause 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:
IMinClause Interface.

groupBy

IMin 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:
IMin Interface.

having

IMinClause 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:
IMinClause Interface.

havingClause

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

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

column

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

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

execute

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

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

Apache License 2.0

Copyright 2013