|
Produced by Siminov Software Solution LLP | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface ICount
Exposes API's to get count of the number of times that X is not NULL in a group. The count(*) function (with no arguments) returns the total number of rows in the group.
Field Summary | |
---|---|
static java.lang.String |
INTERFACE_NAME
|
Method Summary | |
---|---|
ICountClause |
and(java.lang.String column)
Used to specify AND condition between where clause. |
ICount |
column(java.lang.String column)
Used to provide name of column for which count will be calculated. |
ICount |
distinct()
Used to specify DISTINCT condition. |
java.lang.Object |
execute()
Used to get count, this method should be called in last to calculate count. |
ICount |
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. |
ICountClause |
having(java.lang.String column)
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions. |
ICount |
havingClause(java.lang.String havingClause)
Used to provide manually created Where clause, instead of using API's. |
ICountClause |
or(java.lang.String column)
Used to specify OR condition between where clause. |
ICountClause |
where(java.lang.String column)
Column name of which condition will be specified. |
ICount |
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 |
---|
ICount distinct()
ICountClause where(java.lang.String column)
column
- Name of column.
ICount whereClause(java.lang.String whereClause)
whereClause
- Manually created where clause.
ICountClause and(java.lang.String column)
column
- Name of column on which condition need to be specified.
ICountClause or(java.lang.String column)
column
- Name of column on which condition need to be specified.
ICount groupBy(java.lang.String... columns)
columns
- Name of columns.
ICountClause having(java.lang.String column)
column
- Name of column on which condition need to be applied.
ICount havingClause(java.lang.String havingClause)
havingClause
- Where clause.
ICount column(java.lang.String column)
column
- Name of column.
java.lang.Object execute() throws DatabaseException
DatabaseException
- Throws exception if any error occur while calculating count.
|
Apache License 2.0 | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |