SICIMax Protocol Reference
| Conforms to | NSObject |
|---|---|
| Declared in | SICIMax.h |
Overview
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.
– where:
required method
Column name of which condition will be specified.
- (id<SICIMaxClause>)where:(NSString *)columnParameters
column |
Name of column. |
|---|
Return Value
SICIMaxClause Interface.
Discussion
Column name of which condition will be specified.
Declared In
SICIMax.h
– whereClause:
required method
Used to provide manually created Where clause, instead of using API’s.
- (id<SICIMax>)whereClause:(NSString *)whereClauseParameters
whereClause |
Manually created where clause. |
|---|
Return Value
SICIMax Interface.
Discussion
Used to provide manually created Where clause, instead of using API’s.
Declared In
SICIMax.h
– and:
required method
Used to specify AND condition between where clause.
- (id<SICIMaxClause>)and:(NSString *)columnParameters
column |
Name of column on which condition need to be specified. |
|---|
Return Value
SICIMaxClause Interface.
Discussion
Used to specify AND condition between where clause.
Declared In
SICIMax.h
– or:
required method
Used to specify OR condition between where clause.
- (id<SICIMaxClause>)or:(NSString *)columnParameters
column |
Name of column on which condition need to be specified. |
|---|
Return Value
SICIMaxClause Interface.
Discussion
Used to specify OR condition between where clause.
Declared In
SICIMax.h
– groupBy:
required method
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.
- (id<SICIMax>)groupBy:(NSArray *)columnsParameters
columns |
Name of columns. |
|---|
Return Value
SICIMax Interface.
Discussion
Used to specify GROUP BY statement in conjunction with the aggregate functions to group the result-set by one or more columns.
Declared In
SICIMax.h
– having:
required method
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
- (id<SICIMaxClause>)having:(NSString *)columnParameters
column |
Name of column on which condition need to be applied. |
|---|
Return Value
SICIMaxClause Interface.
Discussion
Used to specify HAVING clause to SQL because the WHERE keyword could not be used with aggregate functions.
Declared In
SICIMax.h
– havingClause:
required method
Used to provide manually created Where clause, instead of using API’s.
- (id<SICIMax>)havingClause:(NSString *)havingClauseParameters
havingClause |
Where clause. |
|---|
Return Value
SICIMax Interface.
Discussion
Used to provide manually created Where clause, instead of using API’s.
Declared In
SICIMax.h
– column:
required method
Used to provide name of column for which maximum will be calculated.
- (id<SICIMax>)column:(NSString *)columnParameters
column |
Name of column. |
|---|
Return Value
SICIMax Interface.
Discussion
Used to provide name of column for which maximum will be calculated.
Declared In
SICIMax.h
– execute
required method
Used to get maximum, this method should be called in last to calculate maximum.
- (id)executeReturn Value
Return maximum.
Discussion
Used to get maximum, this method should be called in last to calculate maximum.
Exceptions
SICDatabaseException |
Throws exception if any error occur while calculating maximum. |
|---|
Declared In
SICIMax.h