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
| SELECT TMP.JOUR,
TMP.HEURE,
TMP.MOYENNE
FROM
(
SELECT DAY(CREATION_DATE) AS JOUR,
DATEPART(hour, CREATION_DATE) AS HEURE,
AVG(REQUEST_TIME) AS MOYENNE
FROM dbo.Historique
GROUP BY DAY(CREATION_DATE), DATEPART(hour, CREATION_DATE)
) TMP (JOUR, HEURE, MOYENNE)
JOIN
(
SELECT JOUR, MAX(MOYENNE) AS MaxMoyenne
FROM
(
SELECT DAY(CREATION_DATE) AS JOUR,
DATEPART(hour, CREATION_DATE) AS HEURE,
AVG(REQUEST_TIME) AS MOYENNE
FROM dbo.Historique
GROUP BY DAY(CREATION_DATE), DATEPART(hour, CREATION_DATE)
) BRUT (JOUR, HEURE, MOYENNE)
GROUP BY JOUR
) AGR(JOUR, MaxMoyenne)
ON AGR.MaxMoyenne = TMP.MOYENNE
AND AGR.JOUR = TMP.JOUR |
Partager