如果同时需要日期和值，则需要进行联接：
SELECt ID, Value,As_of from yourTable a inner join(SELECt ID, MAX(As_of) as As_offrom yourTable group by ID) b on a.ID=b.ID and a.As_of = b.As_of
如果同时需要日期和值，则需要进行联接：
SELECt ID, Value,As_of from yourTable a inner join(SELECt ID, MAX(As_of) as As_offrom yourTable group by ID) b on a.ID=b.ID and a.As_of = b.As_of
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
