mysql min where语句 [英] mysql min where statement

问题描述

所以我们有mysql MIN()函数来获取表中的最小值...但是如果我想基于条件获取MIN()怎么办

so we have the mysql MIN() function for getting the minimum in a table...but what if I want to get a MIN() based on a criteria

类似MIN(age)WHERE height< 170

so something like MIN(age) WHERE height < 170

其目的是让只有身高为< 170 ...这样说来，山姆是身高小于<的人中最小的一个. 170，但是pam比sam小，但高度> 170，则查询应返回sam而不是pam ...

in which the aim is to get the minimum age of ONLY people whose height is < 170...so say sam is the youngest of those with height < 170, but pam is younger than sam but have height > 170, then the query should return sam instead of pam...

我将如何构成这样的查询?

how would I compose such query?

推荐答案

您说您要仅身高小于170的人的最低年龄"

You say you want the "minimum age of ONLY people whose height is < 170"

SELECT MIN(age)
FROM YourTable
WHERE height < 170

实际上将按您的要求工作！

Will in fact work as you require then!

WHERE限制行预聚合，HAVING可用于过滤聚合结果.

WHERE limits row pre aggregation, HAVING can be used to filter on the results of aggregations.

这篇关于mysql min where语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！