Where Class Reference
Where
public final class Where: Query, GroupByRouter, OrderByRouter, LimitRouterWhere class represents the WHERE clause of the query statement.
-
Create and chain an ORDER BY component for specifying the orderings of the query result.
Declaration
Swift
public func orderBy(_ orderings: OrderingProtocol...) -> OrderByParameters
orderingsThe ordering objects.
Return Value
The OrderBy object.
-
Create and chain an ORDER BY component for specifying the orderings of the query result.
Declaration
Swift
public func orderBy(_ orderings: [OrderingProtocol]) -> OrderByParameters
orderingsThe ordering objects.
Return Value
The OrderBy object.
-
Create and chain a GROUP BY component to group the query result.
Declaration
Swift
public func groupBy(_ expressions: ExpressionProtocol...) -> GroupByParameters
expressionsThe expression objects.
Return Value
The GroupBy object.
-
Create and chain a GROUP BY component to group the query result.
Declaration
Swift
public func groupBy(_ expressions: [ExpressionProtocol]) -> GroupByParameters
expressionsThe expression objects.
Return Value
The GroupBy object.
-
Create and chain a LIMIT component to limit the number query results.
Declaration
Swift
public func limit(_ limit: ExpressionProtocol) -> LimitParameters
limitThe limit Expression object or liternal value.
Return Value
The Limit object.
-
Create and chain a LIMIT component to skip the returned results for the given offset position and to limit the number of results to not more than the given limit value.
Declaration
Swift
public func limit(_ limit: ExpressionProtocol, offset: ExpressionProtocol?) -> LimitParameters
limitThe limit Expression object or liternal value.
offsetThe offset Expression object or liternal value.
Return Value
The Limit object.