1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| CREATE TABLE T_MESURE (DH DATETIME, MESURE1 FLOAT, MESURE2 FLOAT)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:00:00', 10, 20)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:01:00', 11, 21)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:02:00', 12, 22)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:03:00', 13, 23)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:04:00', 14, 24)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:05:00', 15, 25)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:06:00', 16, 23)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:07:00', 14, 22)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:08:00', 13, 22)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:09:00', 13, 23)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:10:00', 14, 24)
INSERT INTO T_MESURE VALUES ('04/10/2005 16:11:00', 15, 25)
SELECT AVG(MESURE1), AVG(MESURE2), CAST(CAST(TRANCHE AS FLOAT) / 1440 AS DATETIME) AS DH
FROM (SELECT *, CAST(ROUND(CAST(DH AS FLOAT) * 1440.0, 0) AS INTEGER) / 5 AS TRANCHE
FROM T_MESURE) T
GROUP BY TRANCHE |
Partager