Filters the aggregated groups with a boolean SQL expression.
func having(_ predicate: some SQLExpressible) -> Self s4GRDB18AggregatingRequestPAAE6havingyxqd__AA14SQLExpressibleRd__lF What are these?2SSG9For example:
// SELECT teamId, MAX(score)
// FROM player
// GROUP BY teamId
// HAVING MAX(score) > 1000
let request = Player
.select(Column("teamId"), max(Column("score")))
.group(Column("teamId"))
.having(max(Column("score")) > 1000)import GRDBA toolkit for SQLite databases, with a focus on application development
protocol AggregatingRequestA request that can aggregate database rows.
protocol SQLExpressibleA type that can be used as an SQL expression.
func having(literal sqlLiteral: SQL) -> Self Filters the aggregated groups with an SQL literal.
func having(sql: String, arguments: StatementArguments = StatementArguments()) -> Self Filters the aggregated groups with an SQL string.
func havingWhenConnected(_ predicate: @escaping (Database) throws -> any SQLExpressible) -> Self Filters the aggregated groups with a boolean SQL expression.
func group(_ expressions: any SQLExpressible...) -> Self Returns an aggregate request grouped on the given SQL expressions.
func group(_ expressions: [any SQLExpressible]) -> Self Returns an aggregate request grouped on the given SQL expressions.
func group(literal sqlLiteral: SQL) -> Self Returns an aggregate request grouped on an SQL literal.
func group(sql: String, arguments: StatementArguments = StatementArguments()) -> Self Returns an aggregate request grouped on an SQL string.