1 2 3 4 5 6 7 8 9
|
select trtdms, count(trtdms) as nb_lancements, max(datedem) as last_date,
to_char(to_date('01/01/2001 00:00:00','DD/MM/YYYY HH24:MI:SS')+ avg(datfintrt - datedem),'HH24:MI:SS') as duree_moyenne,
to_char(to_date('01/01/2001 00:00:00','DD/MM/YYYY HH24:MI:SS')+ min(datfintrt - datedem),'HH24:MI:SS') as duree_min,
to_char(to_date('01/01/2001 00:00:00','DD/MM/YYYY HH24:MI:SS')+ max(datfintrt - datedem),'HH24:MI:SS') as duree_max
from evt_dms
where datedem >= trunc(sysdate)
and trtok = 1
group by trtdms |
Partager