查询一张表中 某个字段的最大值及其对应记录的其他字段。

//例子：

SELECT b.hkMonth FROM ybc_bill b WHERE b.hkMonth=(SELECT MAX(a.hkMonth) FROM ybc_bill a WHERE a.youthId=b.youthId)

//例子，增加了计算某个字段和，及 分组，排序

SELECT id,`name`,bankId,userId,youthId,isOwn,MIN(c.hkMonth) as minDate,SUM(c.monthlyMoney)as sumMoney,(SELECT b.hkMonth 

 

FROM ybc_bill b WHERE b.youthId =c.youthId AND b.hkMonth=(SELECT MAX(a.hkMonth) FROM ybc_bill a WHERE a.youthId=b.youthId 

 

GROUP BY a.youthId)) AS hkMonth,(SELECT b.monthlyMoney FROM ybc_bill b WHERE b.youthId =c.youthId AND b.hkMonth=(SELECT 

 

MAX(a.hkMonth) FROM ybc_bill a WHERE a.youthId=b.youthId GROUP BY a.youthId)) AS monthlyMoney FROM ybc_bill c GROUP BY 

 

c.youthId;