php - 不遵守Where子句

Question

我在网上找到了以下 sql 查询，如果它正常工作那就完美了，但它不遵守 where 子句。

SELECT *
FROM Chicken AS a,
     (SELECT MIN(Temp) AS mini, MAX(Temp) AS maxi
      FROM Chicken
     ) AS m
WHERE m.maxi = a.Temp AND `Location` = "Outside" OR m.mini = a.Temp AND `Location` = "Outside"
ORDER BY `a`.`Time` DESC Limit 1

发生的情况是，无论位置如何，它都会承受最低和最高温度。我需要它来查找“室外”位置的最低和最高温度。

有人可以帮忙吗？

Answer 1

SELECT *
FROM Chicken AS a,
     (SELECT MIN(Temp) AS mini, MAX(Temp) AS maxi
      FROM Chicken
     ) AS m
WHERE (m.maxi = a.Temp AND `Location` = "Outside") OR (m.mini = a.Temp AND `Location` = "Outside")
ORDER BY `a`.`Time` DESC Limit 1

尝试一下这可能适合您。