Código SQL [-] with t1 as( SELECT N_EXP ,MAX(ord) as ord FROM temp GROUP BY N_EXP), SELECT t2.N_EXP, t2.ASUNTO, t2.FECHA, t2.FOLIOS, t1.ord FROM TEMP t2 inner t1 on t1.N_EXP = t2.N_EXP
with t1 as( SELECT N_EXP ,MAX(ord) as ord FROM temp GROUP BY N_EXP), SELECT t2.N_EXP, t2.ASUNTO, t2.FECHA, t2.FOLIOS, t1.ord FROM TEMP t2 inner t1 on t1.N_EXP = t2.N_EXP