Having

public final class Having: Query, OrderByRouter, LimitRouter

Having represents a HAVING clause of the query statement used for filtering the aggregated values from the the GROUP BY clause.

  • Creates and chains an OrderBy object for specifying the orderings of the query result.

    Declaration

    Swift

    public func orderBy(_ orderings: OrderingProtocol...) -> OrderBy

    Parameters

    orderings

    The Ordering objects.

    Return Value

    The OrderBy object that represents the ORDER BY clause of the query.

  • Creates and chains an OrderBy object for specifying the orderings of the query result.

    Declaration

    Swift

    public func orderBy(_ orderings: [OrderingProtocol]) -> OrderBy

    Parameters

    orderings

    The Ordering objects.

    Return Value

    The OrderBy object that represents the ORDER BY clause of the query.

  • Creates and chains a Limit object to limit the number query results.

    Declaration

    Swift

    public func limit(_ limit: ExpressionProtocol) -> Limit

    Parameters

    limit

    The limit expression.

    Return Value

    The Limit object that represents the LIMIT clause of the query.

  • Creates and chains a Limit object 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?) -> Limit

    Return Value

    The Limit object that represents the LIMIT clause of the query.