|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface ITotal
Exposes API's to return total of all non-NULL values in the group. The non-standard total() function is provided as a convenient way to work around this design problem in the SQL language. The result of total() is always a floating point value.
Field Summary | |
---|---|
static java.lang.String |
INTERFACE_NAME
|
Method Summary | |
---|---|
ITotalClause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
ITotal |
column(java.lang.String column)
Used to provide name of column for which total will be calculated. |
java.lang.Object |
execute()
Used to get total, this method should be called in last to calculate total. |
ITotal |
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. |
ITotalClause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
ITotal |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
ITotalClause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
ITotalClause |
where(java.lang.String column)
Column name of which condition will be specified. |
ITotal |
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 |
---|
ITotalClause where(java.lang.String column)
column
- Name of column.
ITotal whereClause(java.lang.String whereClause)
whereClause
- Manually created where clause.
ITotalClause and(java.lang.String column)
column
- Name of column on which condition need to be specified.
ITotalClause or(java.lang.String column)
column
- Name of column on which condition need to be specified.
ITotal groupBy(java.lang.String... columns)
columns
- Name of columns.
ITotalClause having(java.lang.String column)
column
- Name of column on which condition need to be applied.
ITotal havingClause(java.lang.String havingClause)
havingClause
- Where clause.
ITotal column(java.lang.String column)
column
- Name of column.
java.lang.Object execute() throws DatabaseException
DatabaseException
- Throws exception if any error occur while calculating total.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |