How to Retrieve Column Totals Using GORM?

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:

<code class="go">type SalarySum struct {
    Sum float64
}</code>

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":

<code class="go">query := "SELECT SUM(salary) FROM people"
err := db.Table("people").Select(query).Scan(&salarySum).Error</code>

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.

<code class="go">fmt.Println("Salary sum:", salarySum.Sum)</code>

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

The above is the detailed content of How to Retrieve Column Totals Using GORM?. For more information, please follow other related articles on the PHP Chinese website!