带有 HAVING 和 MAX 的 php mysql 查询 [英] php mysql query with HAVING and MAX

问题描述

您好，我需要一些帮助来使我的 mysql 正确.我需要选择具有最大var"列值的一行.这就是我现在所拥有的，但它没有给出最大值

Hello I need some help getting my mysql correct. I need to select one row which will have the maximum 'var' column value. This is what I have right now but it doesn't give the maximum

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 一起使用:

You can use ORDER BY with LIMIT 1:

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

这篇关于带有 HAVING 和 MAX 的 php mysql 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！