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