在mysql中用groupby查找最小列值

您需要整行具有每个国家的最低费用金额。

• 首先,您需要使用 Group By with Min() t3
• derived table , country和费用值,以获得每个国家费用值最小的行。

尝试以下查询:

SELECT t.*   
FROM trip AS t 
INNER JOIN (SELECT t2.country, MIN(t2.expense) AS min_expense 
            FROM trip AS t2 
            GROUP BY t2.country) AS t3 
  ON t3.min_expense = t.expense 
     AND t3.country = t.country