select max(to_char(mgdate,'yyyy')) ,max(maganize) from tbname where to_char(mgdate,'yyyy')=( select max(to_char(mgdate,'yyyy')) from tbname);
可以用这个 select max(to_char(mgdate,'yyyy')) ,max(maganize) from tbname where to_char(mgdate,'yyyy')=(select max(to_char(mgdate,'yyyy')) from tbname); 不过不能取到月和日。
select max(to_char(mgdate,'yyyy')) from tbname);
select max(to_char(mgdate,'yyyy')) ,max(maganize) from tbname where to_char(mgdate,'yyyy')=(select max(to_char(mgdate,'yyyy')) from tbname);
不过不能取到月和日。