Retrieving Column Totals with GORM

In GORM, obtaining the sum of a column from a database table can be achieved using a few simple steps.

First, define a struct to represent the data you want to retrieve. In this case, if you only need the salary sum, you can create a simple struct with an integer field:

type SalarySum struct {
    Sum float64
}

Next, establish a database connection using gorm.Open(). Then, execute a query using the Table() and Select() methods to specify which table you want to query and what you want to select from it. In this instance, the query is "SELECT SUM(salary) FROM people":

query := "SELECT SUM(salary) FROM people"
err := db.Table("people").Select(query).Scan(&salarySum).Error

Replace the ... with the actual query string.

After executing the query, the result will be stored in the salarySum struct. You can then retrieve the value of the Sum field to get the sum of the salary column.

fmt.Println("Salary sum:", salarySum.Sum)

In summary, by implementing these steps, you can easily obtain the sum of a particular column from a database table using GORM.