你也没有 用取最大值的语句呀。max??不知道你要什么效果

这样吗？？？

SELECT pt.id,pt.pt_number,ptvalue.point_value,ptvalue.input_time,pt.pt_describe 

FROM mom_pro_point pt 

INNER JOIN mom_pro_point_value${"_" + YEAR(date)} ptvalue ON pt.id = ptvalue.point_id

WHERE ptvalue.is_deleted = 0

AND pt.pt_number IN ('KDMDS5L17_0049','KDMDS5L17_0048','KDMDS5L17_0047','KDMDS5L17_0046','KDMDS5L20_0059') 

AND date_format(ptvalue.input_time,'%Y-%m') = '${date}' 

ORDER BY ptvalue.point_value ASC,pt.pt_number

 LIMIT 1

通过排序获取最大值 不应该是用desc吗