select max(id) from t where id like concat(to_char(sysdate,‘yyyyMMdd’) ,’%’);