方式一
max := 0
type MaxStruct struct {
Max int `json:"max"`
}
var result MaxStruct
err := db.Raw("SELECT MAX( functions.order ) AS max FROM functions WHERE app_id = ?", appID).Scan(&result).Error
if err != nil {
common.Log.Error("出错 %v", err)
}
max = result.Max
方式二
max := 0
rows, err := db.Table("functions").Select(" MAX(functions.order) AS max ").Where(" app_id = ? ", appID).Rows()
if err != nil {
common.Log.Error("查询最大值报错 %v", err)
}
if rows.Next() {
err := rows.Scan(&max)
if err != nil {
common.Log.Error("报错 %v", err)
}
}