php - MySQL查询结果之和

Question

我有一个名为“trails”的表，表内有 3 列，分别为“id”、“name”和“grading”。

我有以下查询，它根据 id 给出特定路径名称的最后 5 行。这工作得很好，但现在我需要获得评分栏中 5 个结果的总和？

SELECT * FROM `trails` WHERE `name` = "Free Flow" ORDER BY `id` DESC LIMIT 5

Answer 1

SELECT sum(`grading`)
FROM
  (SELECT *
   FROM `trails`
   WHERE `name` = "Free Flow"
   ORDER BY `id` DESC LIMIT 5) AS TEMP;