//例子:
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;