Aux afficionados du SQL !

CREATE TABLE T_VALUES_VLS
(VLS_DH DATETIME NOT NULL PRIMARY KEY ,
VLS_VALUE INTEGER NOT NULL)

INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-08 18:15:42.000', 0)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:21:51.000', 0)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:22:21.000', 65056)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:22:51.000', 65072)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:23:21.000', 65084)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:23:51.000', 65100)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:24:22.000', 65116)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:24:52.000', 65132)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:25:21.000', 65144)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:25:51.000', 65160)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:26:21.000', 65172)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:26:51.000', 65188)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:27:21.000', 65204)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:27:51.000', 65216)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:28:21.000', 65232)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:28:51.000', 65248)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:29:21.000', 65264)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:29:51.000', 65276)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:30:22.000', 65292)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:30:52.000', 65308)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:31:22.000', 65320)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:31:52.000', 65336)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:32:22.000', 65352)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:32:52.000', 65364)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:33:22.000', 65380)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:33:52.000', 65396)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:34:22.000', 65412)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:34:52.000', 65424)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:35:22.000', 65440)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:35:52.000', 65456)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:36:22.000', 65468)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:36:52.000', 65484)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:37:22.000', 65500)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:37:52.000', 65516)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:38:22.000', 65528)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:38:52.000', 8)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:39:23.000', 24)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:39:53.000', 40)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:40:22.000', 52)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:40:52.000', 68)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:41:22.000', 84)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:41:52.000', 100)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:42:22.000', 112)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:42:52.000', 128)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:43:22.000', 144)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:43:52.000', 156)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:44:22.000', 172)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:44:52.000', 188)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:45:22.000', 204)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:45:52.000', 216)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:46:22.000', 232)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:46:52.000', 248)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:47:22.000', 264)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:47:52.000', 276)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:48:22.000', 292)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:48:52.000', 308)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:49:22.000', 324)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:49:52.000', 336)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:50:22.000', 352)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:50:52.000', 368)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:51:24.000', 384)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:51:54.000', 400)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:52:22.000', 412)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:52:52.000', 428)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:53:22.000', 444)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:53:52.000', 456)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:54:23.000', 472)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:54:53.000', 488)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:55:22.000', 504)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:55:52.000', 520)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:56:22.000', 532)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:56:52.000', 548)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:57:22.000', 564)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:57:52.000', 576)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:58:23.000', 592)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:58:53.000', 608)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:59:23.000', 624)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 15:59:53.000', 640)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:00:23.000', 652)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:00:53.000', 668)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:01:23.000', 684)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:01:53.000', 700)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:02:23.000', 712)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:02:53.000', 728)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:03:23.000', 744)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:03:53.000', 760)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:04:23.000', 772)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:04:53.000', 788)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:05:23.000', 804)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:05:53.000', 820)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:06:24.000', 832)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:06:54.000', 832)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:07:23.000', 832)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:07:53.000', 848)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:08:23.000', 864)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:08:53.000', 872)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:09:23.000', 872)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:09:53.000', 876)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:10:23.000', 892)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:10:53.000', 904)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:11:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:11:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:12:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:12:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:13:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:13:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:14:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:14:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:15:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:15:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:16:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:16:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:17:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:17:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:18:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:18:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:19:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:19:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:20:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:20:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:21:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:21:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:22:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:22:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:23:23.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:23:53.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:24:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:24:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:25:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:25:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:26:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:26:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:27:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:27:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:28:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:28:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:29:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:29:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:30:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:30:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:31:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:31:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:32:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:32:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:33:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:33:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:34:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:34:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:35:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:35:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:36:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:36:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:37:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:37:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:38:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:38:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:39:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:39:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:40:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:40:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:41:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:41:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:42:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:42:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:43:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:43:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:44:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:44:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:45:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:45:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:46:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:46:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:47:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:47:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:48:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:48:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:49:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:49:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:50:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:50:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:51:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:51:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:52:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:52:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:53:24.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:53:54.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:54:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:54:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:55:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:55:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:56:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:56:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:57:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:57:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:58:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:58:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:59:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 16:59:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:00:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:00:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:01:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:01:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:02:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:02:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:03:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:03:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:04:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:04:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:05:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:05:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:06:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:06:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:07:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:07:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:08:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:08:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:09:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:09:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:10:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:10:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:11:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:11:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:12:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:12:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:13:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:13:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:14:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:14:55.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:15:25.000', 912)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:15:55.000', 924)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:16:25.000', 936)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:16:55.000', 952)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:17:25.000', 964)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:17:55.000', 976)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:18:25.000', 992)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:18:55.000', 1004)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:19:25.000', 1020)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:19:55.000', 1032)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:20:26.000', 1048)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:20:56.000', 1064)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:21:26.000', 1076)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:21:56.000', 1092)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:22:26.000', 1104)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:22:56.000', 1120)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:23:26.000', 1136)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:23:56.000', 1148)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:24:26.000', 1164)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:24:56.000', 1180)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:25:26.000', 1196)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:25:56.000', 1208)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:26:26.000', 1224)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:26:56.000', 1240)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:27:26.000', 1252)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:27:56.000', 1268)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:28:26.000', 1284)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:28:56.000', 1300)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:29:26.000', 1312)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:29:56.000', 1328)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:30:26.000', 1344)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:30:56.000', 1360)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:31:26.000', 1372)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:31:56.000', 1388)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:32:26.000', 1404)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:32:56.000', 1420)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:33:26.000', 1432)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:33:56.000', 1448)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:34:26.000', 1464)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:34:56.000', 1480)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:35:26.000', 1496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:35:56.000', 1508)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:36:26.000', 1524)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:36:56.000', 1540)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:37:26.000', 1556)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:37:56.000', 1568)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:38:26.000', 1584)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:38:56.000', 1600)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:39:26.000', 1616)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:39:56.000', 1632)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:40:26.000', 1644)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:40:56.000', 1660)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:41:26.000', 1676)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:41:56.000', 1692)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:42:26.000', 1704)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:42:56.000', 1720)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:43:26.000', 1736)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:43:56.000', 1752)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:44:26.000', 1768)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:44:56.000', 1784)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:45:26.000', 1796)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:45:56.000', 1812)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:46:26.000', 1828)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:46:56.000', 1844)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:47:26.000', 1860)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:47:56.000', 1872)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:48:26.000', 1888)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:48:56.000', 1904)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:49:26.000', 1920)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:49:56.000', 1936)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:50:27.000', 1952)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:50:57.000', 1964)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:51:27.000', 1980)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:51:57.000', 1996)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:52:27.000', 2012)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:52:57.000', 2028)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:53:27.000', 2040)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:53:57.000', 2056)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:54:28.000', 2072)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:54:58.000', 2088)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:55:27.000', 2104)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:55:57.000', 2120)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:56:27.000', 2136)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:56:57.000', 2148)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:57:27.000', 2164)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:57:57.000', 2180)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:58:27.000', 2196)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:58:57.000', 2212)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:59:27.000', 2228)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 17:59:57.000', 2240)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:00:27.000', 2256)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:00:57.000', 2272)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:01:27.000', 2288)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:01:57.000', 2304)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:02:27.000', 2320)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:02:57.000', 2336)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:03:27.000', 2348)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:03:57.000', 2364)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:04:27.000', 2380)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:04:57.000', 2396)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:05:27.000', 2412)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:05:57.000', 2416)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:06:28.000', 2416)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:06:58.000', 2424)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:07:27.000', 2440)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:07:57.000', 2456)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:08:27.000', 2456)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:08:57.000', 2456)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:09:28.000', 2468)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:09:58.000', 2484)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:10:28.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:10:58.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:11:27.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:11:57.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:12:28.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:12:58.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:13:28.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:13:58.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:14:28.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:14:58.000', 2496)
INSERT INTO T_VALUES_VLS (VLS_DH , VLS_VALUE )
VALUES ('2003-09-09 18:15:28.000', 2496)


La requête à faire :

SELECT VLS_DH,
VLS_VALUE,
VLS_DH2,
(SELECT VLS3.VLS_VALUE
FROM T_VALUES_VLS VLS3
WHERE VLS3.VLS_DH = VLS4.VLS_DH2) AS VLS_VALUE2
FROM (SELECT VLS_DH, VLS_VALUE,
(SELECT MIN(VLS2.VLS_DH)
FROM T_VALUES_VLS VLS2
WHERE VLS2.VLS_DH > VLS1.VLS_DH) AS VLS_DH2
FROM T_VALUES_VLS VLS1) AS VLS4
WHERE VLS_VALUE <> (SELECT VLS3.VLS_VALUE
FROM T_VALUES_VLS VLS3
WHERE VLS3.VLS_DH = VLS4.VLS_DH2)

Résultat :

VLS_DH VLS_VALUE VLS_DH2 VLS_VALUE2
------------------------------------ ------------------------ ----------
2003-09-09 15:21:51.000 0 2003-09-09 15:22:21.000 65056
2003-09-09 15:22:21.000 65056 2003-09-09 15:22:51.000 65072
2003-09-09 15:22:51.000 65072 2003-09-09 15:23:21.000 65084
2003-09-09 15:23:21.000 65084 2003-09-09 15:23:51.000 65100
2003-09-09 15:23:51.000 65100 2003-09-09 15:24:22.000 65116
2003-09-09 15:24:22.000 65116 2003-09-09 15:24:52.000 65132
2003-09-09 15:24:52.000 65132 2003-09-09 15:25:21.000 65144
2003-09-09 15:25:21.000 65144 2003-09-09 15:25:51.000 65160
2003-09-09 15:25:51.000 65160 2003-09-09 15:26:21.000 65172
2003-09-09 15:26:21.000 65172 2003-09-09 15:26:51.000 65188
2003-09-09 15:26:51.000 65188 2003-09-09 15:27:21.000 65204
2003-09-09 15:27:21.000 65204 2003-09-09 15:27:51.000 65216
2003-09-09 15:27:51.000 65216 2003-09-09 15:28:21.000 65232
2003-09-09 15:28:21.000 65232 2003-09-09 15:28:51.000 65248
2003-09-09 15:28:51.000 65248 2003-09-09 15:29:21.000 65264
2003-09-09 15:29:21.000 65264 2003-09-09 15:29:51.000 65276
2003-09-09 15:29:51.000 65276 2003-09-09 15:30:22.000 65292
2003-09-09 15:30:22.000 65292 2003-09-09 15:30:52.000 65308
2003-09-09 15:30:52.000 65308 2003-09-09 15:31:22.000 65320
2003-09-09 15:31:22.000 65320 2003-09-09 15:31:52.000 65336
2003-09-09 15:31:52.000 65336 2003-09-09 15:32:22.000 65352
2003-09-09 15:32:22.000 65352 2003-09-09 15:32:52.000 65364
2003-09-09 15:32:52.000 65364 2003-09-09 15:33:22.000 65380
2003-09-09 15:33:22.000 65380 2003-09-09 15:33:52.000 65396
2003-09-09 15:33:52.000 65396 2003-09-09 15:34:22.000 65412
2003-09-09 15:34:22.000 65412 2003-09-09 15:34:52.000 65424
2003-09-09 15:34:52.000 65424 2003-09-09 15:35:22.000 65440
2003-09-09 15:35:22.000 65440 2003-09-09 15:35:52.000 65456
2003-09-09 15:35:52.000 65456 2003-09-09 15:36:22.000 65468
2003-09-09 15:36:22.000 65468 2003-09-09 15:36:52.000 65484
2003-09-09 15:36:52.000 65484 2003-09-09 15:37:22.000 65500
2003-09-09 15:37:22.000 65500 2003-09-09 15:37:52.000 65516
2003-09-09 15:37:52.000 65516 2003-09-09 15:38:22.000 65528
2003-09-09 15:38:22.000 65528 2003-09-09 15:38:52.000 8
2003-09-09 15:38:52.000 8 2003-09-09 15:39:23.000 24
2003-09-09 15:39:23.000 24 2003-09-09 15:39:53.000 40
2003-09-09 15:39:53.000 40 2003-09-09 15:40:22.000 52
2003-09-09 15:40:22.000 52 2003-09-09 15:40:52.000 68
2003-09-09 15:40:52.000 68 2003-09-09 15:41:22.000 84
2003-09-09 15:41:22.000 84 2003-09-09 15:41:52.000 100
2003-09-09 15:41:52.000 100 2003-09-09 15:42:22.000 112
2003-09-09 15:42:22.000 112 2003-09-09 15:42:52.000 128
2003-09-09 15:42:52.000 128 2003-09-09 15:43:22.000 144
2003-09-09 15:43:22.000 144 2003-09-09 15:43:52.000 156
2003-09-09 15:43:52.000 156 2003-09-09 15:44:22.000 172
2003-09-09 15:44:22.000 172 2003-09-09 15:44:52.000 188
2003-09-09 15:44:52.000 188 2003-09-09 15:45:22.000 204
2003-09-09 15:45:22.000 204 2003-09-09 15:45:52.000 216
2003-09-09 15:45:52.000 216 2003-09-09 15:46:22.000 232
2003-09-09 15:46:22.000 232 2003-09-09 15:46:52.000 248
2003-09-09 15:46:52.000 248 2003-09-09 15:47:22.000 264
2003-09-09 15:47:22.000 264 2003-09-09 15:47:52.000 276
2003-09-09 15:47:52.000 276 2003-09-09 15:48:22.000 292
2003-09-09 15:48:22.000 292 2003-09-09 15:48:52.000 308
2003-09-09 15:48:52.000 308 2003-09-09 15:49:22.000 324
2003-09-09 15:49:22.000 324 2003-09-09 15:49:52.000 336
2003-09-09 15:49:52.000 336 2003-09-09 15:50:22.000 352
2003-09-09 15:50:22.000 352 2003-09-09 15:50:52.000 368
2003-09-09 15:50:52.000 368 2003-09-09 15:51:24.000 384
2003-09-09 15:51:24.000 384 2003-09-09 15:51:54.000 400
2003-09-09 15:51:54.000 400 2003-09-09 15:52:22.000 412
2003-09-09 15:52:22.000 412 2003-09-09 15:52:52.000 428
2003-09-09 15:52:52.000 428 2003-09-09 15:53:22.000 444
2003-09-09 15:53:22.000 444 2003-09-09 15:53:52.000 456
2003-09-09 15:53:52.000 456 2003-09-09 15:54:23.000 472
2003-09-09 15:54:23.000 472 2003-09-09 15:54:53.000 488
2003-09-09 15:54:53.000 488 2003-09-09 15:55:22.000 504
2003-09-09 15:55:22.000 504 2003-09-09 15:55:52.000 520
2003-09-09 15:55:52.000 520 2003-09-09 15:56:22.000 532
2003-09-09 15:56:22.000 532 2003-09-09 15:56:52.000 548
2003-09-09 15:56:52.000 548 2003-09-09 15:57:22.000 564
2003-09-09 15:57:22.000 564 2003-09-09 15:57:52.000 576
2003-09-09 15:57:52.000 576 2003-09-09 15:58:23.000 592
2003-09-09 15:58:23.000 592 2003-09-09 15:58:53.000 608
2003-09-09 15:58:53.000 608 2003-09-09 15:59:23.000 624
2003-09-09 15:59:23.000 624 2003-09-09 15:59:53.000 640
2003-09-09 15:59:53.000 640 2003-09-09 16:00:23.000 652
2003-09-09 16:00:23.000 652 2003-09-09 16:00:53.000 668
2003-09-09 16:00:53.000 668 2003-09-09 16:01:23.000 684
2003-09-09 16:01:23.000 684 2003-09-09 16:01:53.000 700
2003-09-09 16:01:53.000 700 2003-09-09 16:02:23.000 712
2003-09-09 16:02:23.000 712 2003-09-09 16:02:53.000 728
2003-09-09 16:02:53.000 728 2003-09-09 16:03:23.000 744
2003-09-09 16:03:23.000 744 2003-09-09 16:03:53.000 760
2003-09-09 16:03:53.000 760 2003-09-09 16:04:23.000 772
2003-09-09 16:04:23.000 772 2003-09-09 16:04:53.000 788
2003-09-09 16:04:53.000 788 2003-09-09 16:05:23.000 804
2003-09-09 16:05:23.000 804 2003-09-09 16:05:53.000 820
2003-09-09 16:05:53.000 820 2003-09-09 16:06:24.000 832
2003-09-09 16:07:23.000 832 2003-09-09 16:07:53.000 848
2003-09-09 16:07:53.000 848 2003-09-09 16:08:23.000 864
2003-09-09 16:08:23.000 864 2003-09-09 16:08:53.000 872
2003-09-09 16:09:23.000 872 2003-09-09 16:09:53.000 876
2003-09-09 16:09:53.000 876 2003-09-09 16:10:23.000 892
2003-09-09 16:10:23.000 892 2003-09-09 16:10:53.000 904
2003-09-09 16:10:53.000 904 2003-09-09 16:11:23.000 912
2003-09-09 17:15:25.000 912 2003-09-09 17:15:55.000 924
2003-09-09 17:15:55.000 924 2003-09-09 17:16:25.000 936
2003-09-09 17:16:25.000 936 2003-09-09 17:16:55.000 952
2003-09-09 17:16:55.000 952 2003-09-09 17:17:25.000 964
2003-09-09 17:17:25.000 964 2003-09-09 17:17:55.000 976
2003-09-09 17:17:55.000 976 2003-09-09 17:18:25.000 992
2003-09-09 17:18:25.000 992 2003-09-09 17:18:55.000 1004
2003-09-09 17:18:55.000 1004 2003-09-09 17:19:25.000 1020
2003-09-09 17:19:25.000 1020 2003-09-09 17:19:55.000 1032
2003-09-09 17:19:55.000 1032 2003-09-09 17:20:26.000 1048
2003-09-09 17:20:26.000 1048 2003-09-09 17:20:56.000 1064
2003-09-09 17:20:56.000 1064 2003-09-09 17:21:26.000 1076
2003-09-09 17:21:26.000 1076 2003-09-09 17:21:56.000 1092
2003-09-09 17:21:56.000 1092 2003-09-09 17:22:26.000 1104
2003-09-09 17:22:26.000 1104 2003-09-09 17:22:56.000 1120
2003-09-09 17:22:56.000 1120 2003-09-09 17:23:26.000 1136
2003-09-09 17:23:26.000 1136 2003-09-09 17:23:56.000 1148
2003-09-09 17:23:56.000 1148 2003-09-09 17:24:26.000 1164
2003-09-09 17:24:26.000 1164 2003-09-09 17:24:56.000 1180
2003-09-09 17:24:56.000 1180 2003-09-09 17:25:26.000 1196
2003-09-09 17:25:26.000 1196 2003-09-09 17:25:56.000 1208
2003-09-09 17:25:56.000 1208 2003-09-09 17:26:26.000 1224
2003-09-09 17:26:26.000 1224 2003-09-09 17:26:56.000 1240
2003-09-09 17:26:56.000 1240 2003-09-09 17:27:26.000 1252
2003-09-09 17:27:26.000 1252 2003-09-09 17:27:56.000 1268
2003-09-09 17:27:56.000 1268 2003-09-09 17:28:26.000 1284
2003-09-09 17:28:26.000 1284 2003-09-09 17:28:56.000 1300
2003-09-09 17:28:56.000 1300 2003-09-09 17:29:26.000 1312
2003-09-09 17:29:26.000 1312 2003-09-09 17:29:56.000 1328
2003-09-09 17:29:56.000 1328 2003-09-09 17:30:26.000 1344
2003-09-09 17:30:26.000 1344 2003-09-09 17:30:56.000 1360
2003-09-09 17:30:56.000 1360 2003-09-09 17:31:26.000 1372
2003-09-09 17:31:26.000 1372 2003-09-09 17:31:56.000 1388
2003-09-09 17:31:56.000 1388 2003-09-09 17:32:26.000 1404
2003-09-09 17:32:26.000 1404 2003-09-09 17:32:56.000 1420
2003-09-09 17:32:56.000 1420 2003-09-09 17:33:26.000 1432
2003-09-09 17:33:26.000 1432 2003-09-09 17:33:56.000 1448
2003-09-09 17:33:56.000 1448 2003-09-09 17:34:26.000 1464
2003-09-09 17:34:26.000 1464 2003-09-09 17:34:56.000 1480
2003-09-09 17:34:56.000 1480 2003-09-09 17:35:26.000 1496
2003-09-09 17:35:26.000 1496 2003-09-09 17:35:56.000 1508
2003-09-09 17:35:56.000 1508 2003-09-09 17:36:26.000 1524
2003-09-09 17:36:26.000 1524 2003-09-09 17:36:56.000 1540
2003-09-09 17:36:56.000 1540 2003-09-09 17:37:26.000 1556
2003-09-09 17:37:26.000 1556 2003-09-09 17:37:56.000 1568
2003-09-09 17:37:56.000 1568 2003-09-09 17:38:26.000 1584
2003-09-09 17:38:26.000 1584 2003-09-09 17:38:56.000 1600
2003-09-09 17:38:56.000 1600 2003-09-09 17:39:26.000 1616
2003-09-09 17:39:26.000 1616 2003-09-09 17:39:56.000 1632
2003-09-09 17:39:56.000 1632 2003-09-09 17:40:26.000 1644
2003-09-09 17:40:26.000 1644 2003-09-09 17:40:56.000 1660
2003-09-09 17:40:56.000 1660 2003-09-09 17:41:26.000 1676
2003-09-09 17:41:26.000 1676 2003-09-09 17:41:56.000 1692
2003-09-09 17:41:56.000 1692 2003-09-09 17:42:26.000 1704
2003-09-09 17:42:26.000 1704 2003-09-09 17:42:56.000 1720
2003-09-09 17:42:56.000 1720 2003-09-09 17:43:26.000 1736
2003-09-09 17:43:26.000 1736 2003-09-09 17:43:56.000 1752
2003-09-09 17:43:56.000 1752 2003-09-09 17:44:26.000 1768
2003-09-09 17:44:26.000 1768 2003-09-09 17:44:56.000 1784
2003-09-09 17:44:56.000 1784 2003-09-09 17:45:26.000 1796
2003-09-09 17:45:26.000 1796 2003-09-09 17:45:56.000 1812
2003-09-09 17:45:56.000 1812 2003-09-09 17:46:26.000 1828
2003-09-09 17:46:26.000 1828 2003-09-09 17:46:56.000 1844
2003-09-09 17:46:56.000 1844 2003-09-09 17:47:26.000 1860
2003-09-09 17:47:26.000 1860 2003-09-09 17:47:56.000 1872
2003-09-09 17:47:56.000 1872 2003-09-09 17:48:26.000 1888
2003-09-09 17:48:26.000 1888 2003-09-09 17:48:56.000 1904
2003-09-09 17:48:56.000 1904 2003-09-09 17:49:26.000 1920
2003-09-09 17:49:26.000 1920 2003-09-09 17:49:56.000 1936
2003-09-09 17:49:56.000 1936 2003-09-09 17:50:27.000 1952
2003-09-09 17:50:27.000 1952 2003-09-09 17:50:57.000 1964
2003-09-09 17:50:57.000 1964 2003-09-09 17:51:27.000 1980
2003-09-09 17:51:27.000 1980 2003-09-09 17:51:57.000 1996
2003-09-09 17:51:57.000 1996 2003-09-09 17:52:27.000 2012
2003-09-09 17:52:27.000 2012 2003-09-09 17:52:57.000 2028
2003-09-09 17:52:57.000 2028 2003-09-09 17:53:27.000 2040
2003-09-09 17:53:27.000 2040 2003-09-09 17:53:57.000 2056
2003-09-09 17:53:57.000 2056 2003-09-09 17:54:28.000 2072
2003-09-09 17:54:28.000 2072 2003-09-09 17:54:58.000 2088
2003-09-09 17:54:58.000 2088 2003-09-09 17:55:27.000 2104
2003-09-09 17:55:27.000 2104 2003-09-09 17:55:57.000 2120
2003-09-09 17:55:57.000 2120 2003-09-09 17:56:27.000 2136
2003-09-09 17:56:27.000 2136 2003-09-09 17:56:57.000 2148
2003-09-09 17:56:57.000 2148 2003-09-09 17:57:27.000 2164
2003-09-09 17:57:27.000 2164 2003-09-09 17:57:57.000 2180
2003-09-09 17:57:57.000 2180 2003-09-09 17:58:27.000 2196
2003-09-09 17:58:27.000 2196 2003-09-09 17:58:57.000 2212
2003-09-09 17:58:57.000 2212 2003-09-09 17:59:27.000 2228
2003-09-09 17:59:27.000 2228 2003-09-09 17:59:57.000 2240
2003-09-09 17:59:57.000 2240 2003-09-09 18:00:27.000 2256
2003-09-09 18:00:27.000 2256 2003-09-09 18:00:57.000 2272
2003-09-09 18:00:57.000 2272 2003-09-09 18:01:27.000 2288
2003-09-09 18:01:27.000 2288 2003-09-09 18:01:57.000 2304
2003-09-09 18:01:57.000 2304 2003-09-09 18:02:27.000 2320
2003-09-09 18:02:27.000 2320 2003-09-09 18:02:57.000 2336
2003-09-09 18:02:57.000 2336 2003-09-09 18:03:27.000 2348
2003-09-09 18:03:27.000 2348 2003-09-09 18:03:57.000 2364
2003-09-09 18:03:57.000 2364 2003-09-09 18:04:27.000 2380
2003-09-09 18:04:27.000 2380 2003-09-09 18:04:57.000 2396
2003-09-09 18:04:57.000 2396 2003-09-09 18:05:27.000 2412
2003-09-09 18:05:27.000 2412 2003-09-09 18:05:57.000 2416
2003-09-09 18:06:28.000 2416 2003-09-09 18:06:58.000 2424
2003-09-09 18:06:58.000 2424 2003-09-09 18:07:27.000 2440
2003-09-09 18:07:27.000 2440 2003-09-09 18:07:57.000 2456
2003-09-09 18:08:57.000 2456 2003-09-09 18:09:28.000 2468
2003-09-09 18:09:28.000 2468 2003-09-09 18:09:58.000 2484
2003-09-09 18:09:58.000 2484 2003-09-09 18:10:28.000 2496



yves a écrit:

Bonjours,

Voilà, j'ai un exercice à vous proposer...
J'ai une table TABLE avec les enregistrements suivants:

DATE_TIME , VALEUR
2003-09-08 18:15:42,0
2003-09-09 15:21:51,0
2003-09-09 15:22:21,65056
2003-09-09 15:22:51,65072
2003-09-09 15:23:21,65084
2003-09-09 15:23:51,65100
2003-09-09 15:24:22,65116
2003-09-09 15:24:52,65132
2003-09-09 15:25:21,65144
2003-09-09 15:25:51,65160
2003-09-09 15:26:21,65172
2003-09-09 15:26:51,65188
2003-09-09 15:27:21,65204
2003-09-09 15:27:51,65216
2003-09-09 15:28:21,65232
2003-09-09 15:28:51,65248
2003-09-09 15:29:21,65264
2003-09-09 15:29:51,65276
2003-09-09 15:30:22,65292
2003-09-09 15:30:52,65308
2003-09-09 15:31:22,65320
2003-09-09 15:31:52,65336
2003-09-09 15:32:22,65352
2003-09-09 15:32:52,65364
2003-09-09 15:33:22,65380
2003-09-09 15:33:52,65396
2003-09-09 15:34:22,65412
2003-09-09 15:34:52,65424
2003-09-09 15:35:22,65440
2003-09-09 15:35:52,65456
2003-09-09 15:36:22,65468
2003-09-09 15:36:52,65484
2003-09-09 15:37:22,65500
2003-09-09 15:37:52,65516
2003-09-09 15:38:22,65528
2003-09-09 15:38:52,8
2003-09-09 15:39:23,24
2003-09-09 15:39:53,40
2003-09-09 15:40:22,52
2003-09-09 15:40:52,68
2003-09-09 15:41:22,84
2003-09-09 15:41:52,100
2003-09-09 15:42:22,112
2003-09-09 15:42:52,128
2003-09-09 15:43:22,144
2003-09-09 15:43:52,156
2003-09-09 15:44:22,172
2003-09-09 15:44:52,188
2003-09-09 15:45:22,204
2003-09-09 15:45:52,216
2003-09-09 15:46:22,232
2003-09-09 15:46:52,248
2003-09-09 15:47:22,264
2003-09-09 15:47:52,276
2003-09-09 15:48:22,292
2003-09-09 15:48:52,308
2003-09-09 15:49:22,324
2003-09-09 15:49:52,336
2003-09-09 15:50:22,352
2003-09-09 15:50:52,368
2003-09-09 15:51:24,384
2003-09-09 15:51:54,400
2003-09-09 15:52:22,412
2003-09-09 15:52:52,428
2003-09-09 15:53:22,444
2003-09-09 15:53:52,456
2003-09-09 15:54:23,472
2003-09-09 15:54:53,488
2003-09-09 15:55:22,504
2003-09-09 15:55:52,520
2003-09-09 15:56:22,532
2003-09-09 15:56:52,548
2003-09-09 15:57:22,564
2003-09-09 15:57:52,576
2003-09-09 15:58:23,592
2003-09-09 15:58:53,608
2003-09-09 15:59:23,624
2003-09-09 15:59:53,640
2003-09-09 16:00:23,652
2003-09-09 16:00:53,668
2003-09-09 16:01:23,684
2003-09-09 16:01:53,700
2003-09-09 16:02:23,712
2003-09-09 16:02:53,728
2003-09-09 16:03:23,744
2003-09-09 16:03:53,760
2003-09-09 16:04:23,772
2003-09-09 16:04:53,788
2003-09-09 16:05:23,804
2003-09-09 16:05:53,820
2003-09-09 16:06:24,832
2003-09-09 16:06:54,832
2003-09-09 16:07:23,832
2003-09-09 16:07:53,848
2003-09-09 16:08:23,864
2003-09-09 16:08:53,872
2003-09-09 16:09:23,872
2003-09-09 16:09:53,876
2003-09-09 16:10:23,892
2003-09-09 16:10:53,904
2003-09-09 16:11:23,912
2003-09-09 16:11:53,912
2003-09-09 16:12:23,912
2003-09-09 16:12:53,912
2003-09-09 16:13:23,912
2003-09-09 16:13:53,912
2003-09-09 16:14:23,912
2003-09-09 16:14:53,912
2003-09-09 16:15:23,912
2003-09-09 16:15:53,912
2003-09-09 16:16:23,912
2003-09-09 16:16:53,912
2003-09-09 16:17:23,912
2003-09-09 16:17:53,912
2003-09-09 16:18:23,912
2003-09-09 16:18:53,912
2003-09-09 16:19:23,912
2003-09-09 16:19:53,912
2003-09-09 16:20:23,912
2003-09-09 16:20:53,912
2003-09-09 16:21:24,912
2003-09-09 16:21:54,912
2003-09-09 16:22:23,912
2003-09-09 16:22:53,912
2003-09-09 16:23:23,912
2003-09-09 16:23:53,912
2003-09-09 16:24:24,912
2003-09-09 16:24:54,912
2003-09-09 16:25:24,912
2003-09-09 16:25:54,912
2003-09-09 16:26:24,912
2003-09-09 16:26:54,912
2003-09-09 16:27:24,912
2003-09-09 16:27:54,912
2003-09-09 16:28:24,912
2003-09-09 16:28:54,912
2003-09-09 16:29:24,912
2003-09-09 16:29:54,912
2003-09-09 16:30:24,912
2003-09-09 16:30:54,912
2003-09-09 16:31:24,912
2003-09-09 16:31:54,912
2003-09-09 16:32:24,912
2003-09-09 16:32:54,912
2003-09-09 16:33:24,912
2003-09-09 16:33:54,912
2003-09-09 16:34:24,912
2003-09-09 16:34:54,912
2003-09-09 16:35:24,912
2003-09-09 16:35:54,912
2003-09-09 16:36:24,912
2003-09-09 16:36:54,912
2003-09-09 16:37:24,912
2003-09-09 16:37:54,912
2003-09-09 16:38:24,912
2003-09-09 16:38:54,912
2003-09-09 16:39:24,912
2003-09-09 16:39:54,912
2003-09-09 16:40:24,912
2003-09-09 16:40:54,912
2003-09-09 16:41:24,912
2003-09-09 16:41:54,912
2003-09-09 16:42:24,912
2003-09-09 16:42:54,912
2003-09-09 16:43:24,912
2003-09-09 16:43:54,912
2003-09-09 16:44:24,912
2003-09-09 16:44:54,912
2003-09-09 16:45:24,912
2003-09-09 16:45:54,912
2003-09-09 16:46:24,912
2003-09-09 16:46:54,912
2003-09-09 16:47:24,912
2003-09-09 16:47:54,912
2003-09-09 16:48:24,912
2003-09-09 16:48:54,912
2003-09-09 16:49:24,912
2003-09-09 16:49:54,912
2003-09-09 16:50:25,912
2003-09-09 16:50:55,912
2003-09-09 16:51:25,912
2003-09-09 16:51:55,912
2003-09-09 16:52:24,912
2003-09-09 16:52:54,912
2003-09-09 16:53:24,912
2003-09-09 16:53:54,912
2003-09-09 16:54:25,912
2003-09-09 16:54:55,912
2003-09-09 16:55:25,912
2003-09-09 16:55:55,912
2003-09-09 16:56:25,912
2003-09-09 16:56:55,912
2003-09-09 16:57:25,912
2003-09-09 16:57:55,912
2003-09-09 16:58:25,912
2003-09-09 16:58:55,912
2003-09-09 16:59:25,912
2003-09-09 16:59:55,912
2003-09-09 17:00:25,912
2003-09-09 17:00:55,912
2003-09-09 17:01:25,912
2003-09-09 17:01:55,912
2003-09-09 17:02:25,912
2003-09-09 17:02:55,912
2003-09-09 17:03:25,912
2003-09-09 17:03:55,912
2003-09-09 17:04:25,912
2003-09-09 17:04:55,912
2003-09-09 17:05:25,912
2003-09-09 17:05:55,912
2003-09-09 17:06:25,912
2003-09-09 17:06:55,912
2003-09-09 17:07:25,912
2003-09-09 17:07:55,912
2003-09-09 17:08:25,912
2003-09-09 17:08:55,912
2003-09-09 17:09:25,912
2003-09-09 17:09:55,912
2003-09-09 17:10:25,912
2003-09-09 17:10:55,912
2003-09-09 17:11:25,912
2003-09-09 17:11:55,912
2003-09-09 17:12:25,912
2003-09-09 17:12:55,912
2003-09-09 17:13:25,912
2003-09-09 17:13:55,912
2003-09-09 17:14:25,912
2003-09-09 17:14:55,912
2003-09-09 17:15:25,912
2003-09-09 17:15:55,924
2003-09-09 17:16:25,936
2003-09-09 17:16:55,952
2003-09-09 17:17:25,964
2003-09-09 17:17:55,976
2003-09-09 17:18:25,992
2003-09-09 17:18:55,1004
2003-09-09 17:19:25,1020
2003-09-09 17:19:55,1032
2003-09-09 17:20:26,1048
2003-09-09 17:20:56,1064
2003-09-09 17:21:26,1076
2003-09-09 17:21:56,1092
2003-09-09 17:22:26,1104
2003-09-09 17:22:56,1120
2003-09-09 17:23:26,1136
2003-09-09 17:23:56,1148
2003-09-09 17:24:26,1164
2003-09-09 17:24:56,1180
2003-09-09 17:25:26,1196
2003-09-09 17:25:56,1208
2003-09-09 17:26:26,1224
2003-09-09 17:26:56,1240
2003-09-09 17:27:26,1252
2003-09-09 17:27:56,1268
2003-09-09 17:28:26,1284
2003-09-09 17:28:56,1300
2003-09-09 17:29:26,1312
2003-09-09 17:29:56,1328
2003-09-09 17:30:26,1344
2003-09-09 17:30:56,1360
2003-09-09 17:31:26,1372
2003-09-09 17:31:56,1388
2003-09-09 17:32:26,1404
2003-09-09 17:32:56,1420
2003-09-09 17:33:26,1432
2003-09-09 17:33:56,1448
2003-09-09 17:34:26,1464
2003-09-09 17:34:56,1480
2003-09-09 17:35:26,1496
2003-09-09 17:35:56,1508
2003-09-09 17:36:26,1524
2003-09-09 17:36:56,1540
2003-09-09 17:37:26,1556
2003-09-09 17:37:56,1568
2003-09-09 17:38:26,1584
2003-09-09 17:38:56,1600
2003-09-09 17:39:26,1616
2003-09-09 17:39:56,1632
2003-09-09 17:40:26,1644
2003-09-09 17:40:56,1660
2003-09-09 17:41:26,1676
2003-09-09 17:41:56,1692
2003-09-09 17:42:26,1704
2003-09-09 17:42:56,1720
2003-09-09 17:43:26,1736
2003-09-09 17:43:56,1752
2003-09-09 17:44:26,1768
2003-09-09 17:44:56,1784
2003-09-09 17:45:26,1796
2003-09-09 17:45:56,1812
2003-09-09 17:46:26,1828
2003-09-09 17:46:56,1844
2003-09-09 17:47:26,1860
2003-09-09 17:47:56,1872
2003-09-09 17:48:26,1888
2003-09-09 17:48:56,1904
2003-09-09 17:49:26,1920
2003-09-09 17:49:56,1936
2003-09-09 17:50:27,1952
2003-09-09 17:50:57,1964
2003-09-09 17:51:27,1980
2003-09-09 17:51:57,1996
2003-09-09 17:52:27,2012
2003-09-09 17:52:57,2028
2003-09-09 17:53:27,2040
2003-09-09 17:53:57,2056
2003-09-09 17:54:28,2072
2003-09-09 17:54:58,2088
2003-09-09 17:55:27,2104
2003-09-09 17:55:57,2120
2003-09-09 17:56:27,2136
2003-09-09 17:56:57,2148
2003-09-09 17:57:27,2164
2003-09-09 17:57:57,2180
2003-09-09 17:58:27,2196
2003-09-09 17:58:57,2212
2003-09-09 17:59:27,2228
2003-09-09 17:59:57,2240
2003-09-09 18:00:27,2256
2003-09-09 18:00:57,2272
2003-09-09 18:01:27,2288
2003-09-09 18:01:57,2304
2003-09-09 18:02:27,2320
2003-09-09 18:02:57,2336
2003-09-09 18:03:27,2348
2003-09-09 18:03:57,2364
2003-09-09 18:04:27,2380
2003-09-09 18:04:57,2396
2003-09-09 18:05:27,2412
2003-09-09 18:05:57,2416
2003-09-09 18:06:28,2416
2003-09-09 18:06:58,2424
2003-09-09 18:07:27,2440
2003-09-09 18:07:57,2456
2003-09-09 18:08:27,2456
2003-09-09 18:08:57,2456
2003-09-09 18:09:28,2468
2003-09-09 18:09:58,2484
2003-09-09 18:10:28,2496
2003-09-09 18:10:58,2496
2003-09-09 18:11:27,2496
2003-09-09 18:11:57,2496
2003-09-09 18:12:28,2496
2003-09-09 18:12:58,2496
2003-09-09 18:13:28,2496
2003-09-09 18:13:58,2496
2003-09-09 18:14:28,2496
2003-09-09 18:14:58,2496
2003-09-09 18:15:28,2496

BdD Mysql + PHP...

En fait c'est un compteur qui est archivé dans la table à peu près toutes
les 30s ...
Ce compteur n'évolue pas continuellement mais présente des paliers ...

Sachant qu'il faut calculer le cumul des valeurs sur une semaine entière et
que je ne voudrais pas
faire la boucle en PHP sur toutes les valeurs...

Le but de l'exercice consiste à trouver la requete qui me donne que les
valeurs qui ont changé d'un enregistrement
à l'autre et donc revient à filtrer les paliers ...(qui n'ont aucune valeur
ajouté pour le calcul du cumul)
(Ce sont les impulsions d'un débitmètre pour le dosage d'un ingrédient...)

L'exercice consiste bien sur a connaitre également la Date_Heure de début et
de fin de chaque dosage...que je
peux encore traiter avec PHP

J'ai déjà un exemple de requete du style:
SELECT a1.Timestp, a1.Valeur
from TABLE as a1, TABLE as a2
where
a1.TIMESTP >= '".$sDateHeureDebut."' and a1.TIMESTP <'".$sDateHeureFin."'
and
a1.TIMESTP = date_sub( a2.TIMESTP, INTERVAL 30 SECOND ) and
(a1.Valeur - a2.Valeur) > 0
order by a1.TIMESTP

mais ceci ne marche pas toujours car la variation du Timestp n'est pas
toujours forcément de 30s...
et je perd donc des enregistrements.
La difficulté consiste à faire une relation de la table sur une copie
d'elle-même mais avec un enregistrement décalé en arrière
(ou en avant) .

Si quelqu'un à un artifice ou solution à me proposer je lui payerai
volontier une bonne bière...

Cdlt,

--
Frédéric BROUARD - expert SQL, spécialiste : SQL Server / Delphi / web
Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html
Le site du SQL, pour débutants et pros : http://sqlpro.developpez.com
****************** mailto:brouardf@club-internet.fr ******************