Get SQL function results

To output the result of a SQL function such as COUNT, MAX or SUM, use the AS keyword to select the function result into an output variable, then run the query.

For example:

type Count struct {
    Num int `db:"num"`
}

stmt, err := sqlair.Prepare(
    "SELECT COUNT(*) AS &Count.num FROM employees", 
    Count{},
)
if err != nil {
    return err
}

var count Count
err := db.Query(ctx, stmt).Get(&count)
if err != nil {
    return err
}

fmt.Printf("Number of employees: %d", count.Num)

See more

Output expression syntax