select max() from table groupby id的处理方法
问题描述: 需要查找X时间最新的记录 的其他字段。
select * from x*10000+id in (select max(x)*10000+id from table groupby id)
SELECT
ID,
discharge_amount,
check_year
FROM
ims_source_item_summary A
WHERE
discharge_amount IN (
SELECT
MAX (discharge_amount)
FROM
ims_source_item_summary b
WHERE
A .check_year = b.check_year //这个很关键
GROUP BY
check_year
)
ORDER BY check_year