php - 如何反转 MySQL 结果

Question

我需要反转我的输出，但我无法通过切换 ORDER BY 子句来实现。

此代码获取最近 12 个月的数据，但我需要以相反的顺序显示它们。现在它有十月第一，但我需要它来最后。如果我切换到 ORDER BY DATE ASC，那么我会得到错误的月份。

我的代码是这样的:

<?php
$result2 = mysqli_query(
    $con,
    "SELECT SUM(DISTRIBUTED_AMOUNT / EXCHANGE_RATE)
        FROM royalties 
        GROUP BY DATE
        ORDER BY DATE DESC
        LIMIT 12"
);
while($row2 = mysqli_fetch_array($result2)) {
    echo number_format($row2[0], 2, '.', '') . ', ';
}?>

Answer 1

您可以将查询包装在另一个选择中并反转order by:

SELECT res
FROM (
  SELECT `date`,SUM(DISTRIBUTED_AMOUNT / EXCHANGE_RATE) AS res
  FROM royalties
  GROUP BY `date`
  ORDER BY `date` DESC LIMIT 12
  ) a
ORDER BY `date` ASC