Returns an aggregate request grouped on an SQL string.
func group(sql: String, arguments: StatementArguments = StatementArguments()) -> Self s4GRDB18AggregatingRequestPAAE5group3sql9argumentsxSS_AA18StatementArgumentsVtF What are these?5QXRHFor example:
// SELECT teamId, MAX(score)
// FROM player
// GROUP BY teamId
let request = Player
.select(Column("teamId"), max(Column("score")))
.group(sql: "teamId")Any previous grouping is discarded.
import GRDBA toolkit for SQLite databases, with a focus on application development
protocol AggregatingRequestA request that can aggregate database rows.
@frozen struct StringA Unicode string value that is a collection of characters.
struct StatementArgumentsAn instance of StatementArguments provides the values for argument placeholders in a prepared Statement.
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 groupWhenConnected(_ expressions: @escaping (Database) throws -> [any SQLExpressible]) -> Self Returns an aggregate request grouped on the given SQL expressions.
func having(_ predicate: some SQLExpressible) -> Self Filters the aggregated groups with a boolean 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.