Ou como um amigo acabou de sugerir:
with tbl as
(
SELECT /*+ materialize */ ch.codchamado AS "NumeroChamado",
ch.strtitulo AS "Titulo",
tp.strtipo AS "Tipo",
ch.strnomeusuario AS "Solicitante",
st.strstatus AS "Status",
ch.datdatacritica AS "DataCritica",
ch.datcreated AS "DataAbertura",
max(t2.CODHISTORY) max_CODHISTORY
FROM tblchamado ch,
tblstatus st,
tbltipo tp,
tblusuario us,
tblchamadohistory t2
WHERE ch.codstatus = st.codstatus
AND ch.codtipo = tp.codtipo
AND ch.codresolvedor = us.codusuario
AND ch.datcreated >= trunc(sysdate - 7)
AND t2.codchamado = ch.codchamado
GROUP BY ch.codchamado,
ch.strtitulo,
tp.strtipo,
ch.strnomeusuario,
st.strstatus,
ch.datdatacritica,
ch.datcreated,
us.strnome
)
SELECT tbl.*, t1.STRTEXT
FROM tbl, tblchamadohistory t1
WHERE tbl.max_CODHISTORY = t1.CODHISTORY
ORDER BY 1;
Fica o exemplo pra quem precisar utilizar!
Abraço!
