select*from(select t.id,
t.experiment_time,
t.steel_grade,
t.heat_num,
t.C_Actual AS C,
t.Mn_Actual AS Mn,
t.s_Actual AS S,
t.p_Actual AS P,
t.Si_Actual AS Si,
t.Al_Sol_Actual AS Als,
T.B_ACTUAL AS B
from t_qdc_a_steemake_mt_experiment t
where substr(t.sample_no,6,1)='6'and t.heat_num =02356orderby t.experiment_time desc) t
where rownum=1
with tmp as(select t.id,
t.experiment_time,
t.steel_grade,
t.heat_num,
t.C_Actual AS C,
t.Mn_Actual AS Mn,
t.s_Actual AS S,
t.p_Actual AS P,
t.Si_Actual AS Si,
t.Al_Sol_Actual AS Als,
T.B_ACTUAL AS B,max(experiment_time)over(partitionby heat_num)as maxtime
from t_qdc_a_steemake_mt_experiment t )select*from tmp where experiment_time = maxtime
oracleselect * from (select t.id, t.experiment_time, t.steel_grade, t.heat_num, t.C_Actual AS C, t.Mn_Actual AS Mn, t.s_Actual AS S, t.p_Actual AS P, t.Si_Actual AS Si, t.Al_Sol_Actual AS Als,