php mysql query with HAVING and MAX

本文关键字：and MAX HAVING with mysql query php | 更新日期: 2023-09-27

你好，我需要一些帮助得到我的mysql正确。我需要选择一行，这将有最大的"var"列值。这是我现在得到的但它没有给出最大值

SELECT a.* FROM `table` AS a GROUP BY a.var HAVING a.var = MAX(a.var) AND `code` = '1' AND `type` = '0';

您可以使用ORDER BY与LIMIT 1:

SELECT col1, col2, ..., coln
FROM `table`
WHERE `code` = '1' AND `type` = '0'
ORDER BY `var` DESC
LIMIT 1

这可能就是您所需要的:

SELECT MAX(vari)
FROM TABLE
WHERE `code` = '1' AND `type` = '0'