1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
SELECT
SIMULT
, count(CLE)
FROM(
SELECT
E1.CLE,
E1.ID_TYPE_EVENEMENT,
COUNT(*) as SIMULT
FROM TABLE_EVENEMENT E1
INNER JOIN TABLE_EVENEMENT E2
ON E1.CLE <> E2.CLE
AND E2.ID_TYPE_EVENEMENT IN ('A')
AND E2.DH_DEBUT >= TO_DATE('201501','YYYYMM')
AND E2.DH_DEBUT < TO_DATE('201502','YYYYMM')
and (
(E1.DH_DEBUT > E2.DH_DEBUT and E1.DH_DEBUT<E2.DH_FIN)
or(E1.DH_DEBUT<E2.DH_DEBUT and E1.DH_FIN > E2. DH_FIN)
or(E1. DH_FIN < E2. DH_FIN and E1. DH_FIN>E2. DH_DEBUT)
)
WHERE E1.ID_TYPE_EVENEMENT IN ('A')
AND E1.DH_DEBUT >= TO_DATE('201501','YYYYMM')
AND E1.DH_DEBUT < TO_DATE('201502','YYYYMM')
GROUP BY
E1.CLE,
E1.ID_TYPE_EVENEMENT
) E3
GROUP BY SIMULT |
Partager