查找每个uid最晚(大)的enddate时间

查找每个uid最晚(大)的enddate时间

SELECT max(to_number(to_char(enddate,'yyyymmddhh24miss'))),uid from TRAFODION.D.STATE  where SID ='100'  
AND  uid IN('xxx','yyy','zzz') GROUP BY uid;