MySQL - 获取最低值 [英] MySQL - Fetching lowest value

问题描述

我的数据库结构包含列： id，名称，值，经销商。我想为每个 经销商检索最低值的行。我一直在试图搞砸 MIN（）和 GROUP BY ，仍然 - 没有解决方案。

My database structure contains columns: id, name, value, dealer. I want to retrieve row with lowest value for each dealer. I've been trying to mess up with MIN() and GROUP BY, still - no solution.

推荐答案

解决方案1：

Solution1:

SELECT t1.* FROM your_table t1
JOIN (
  SELECT MIN(value) AS min_value, dealer
  FROM your_table 
  GROUP BY dealer
) AS t2 ON t1.dealer = t2.dealer AND t1.value = t2.min_value

解决方案2：

SELECT t1.* FROM your_table t1
LEFT JOIN your_table t2
ON t1.dealer = t2.dealer AND t1.value > t2.value
WHERE t2.value IS NULL

这个问题非常有名，所以在那里这是Mysql手册中的特殊页面。

This problem is very famous, so there is a special page for this in Mysql's manual.

选中此项： 分组持有某一列的最大值/最小值的行

Check this: Rows Holding the Group-wise Maximum/Minimum of a Certain Column

这篇关于MySQL - 获取最低值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！