本文介绍了如何获取Max值的id的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想要按月分组的最大平均值及其ID,
I want the max Average value and its id grouped by month,
Select FK_Transporter,Month, MAX(avg_rate) as BTPercent FROM ( SELECT kpi.FK_Transporter ,kpi.`Month`, AVG(kpi.OnTimeDelivery) as avg_rate FROM primarykpi as kpi,transporter as t WHERE kpi.FK_Transporter=t.Id and YEAR(kpi.`Month`)=2016 GROUP BY FK_Transporter, MONTH(kpi.Month)) tp GROUP BY tp.`Month`这个查询给了我正确的平均值但是id是incor RECT。无法解决错误。这是此查询的输出
This query gave me right average but id is incorrect. Couldn't able to fing the mistake .Here is output of this query
FK_Transporter Month MaxAvg 1 2016-01-01 2.270109534263611 1 2016-02-01 0.8539329767227173 1 2016-03-01 0.6764709949493408FK_transporter是1 in所有记录都错了。我怎样才能解决这个问题。谢谢。
FK_transporter is 1 in all records whch is wrong . How can i fix this. Thanks.
推荐答案SELECT * FROM data WHERE temp_hi =(SELECT MAX(temp_hi)FROM FROM) SELECT * FROM data WHERE temp_hi = (SELECT MAX(temp_hi) FROM data)
更多推荐
如何获取Max值的id
发布评论