none
Maximo y Minimo de una grafica RRS feed

  • Pregunta

  • Hola que tal

    Se me presento un problema al detectar el maximo y minimo de una grafica ya que dicha grafica fluctua mucho 

    Los puntos rojos son los datos que necesito agarrar ( cabe señalar que lo agarro por semana los datos , ya que no puedo poner todos los datos solo pondre los datos del dia que se hubo ese incremento, seria de buena ayuda detectar los dias cuando hay incremento pero como no me permiten poner mucha info en la pregunta , solo pondre lo del dia que se detecto )

    CREATE TABLE mytable(
       Value   INT 
      ,timestamp datetime
    );

    Dato mayor y menor (NEGRITA )

    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:00:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:01:43');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:02:28');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:03:40');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:04:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:05:34');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:06:41');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:07:28');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:08:35');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:09:43');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:10:28');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:11:37');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:12:22');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:13:31');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:14:37');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:15:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:16:31');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:17:41');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:18:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:19:33');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:20:40');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 06:21:26');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:22:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:23:41');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:24:25');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:25:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:26:40');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:27:28');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 06:28:35');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:29:22');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:30:29');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:31:40');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:32:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:33:35');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:34:20');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 06:35:30');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:36:37');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:37:24');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:38:31');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:39:41');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:40:26');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:41:36');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:42:21');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:43:30');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:44:38');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:45:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:46:32');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:47:41');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:48:26');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 06:49:36');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 06:50:20');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:51:30');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 06:52:37');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 06:53:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:54:32');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:55:41');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:56:26');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:57:35');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 06:58:20');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 06:59:29');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:00:36');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:01:23');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:02:30');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:03:41');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:04:25');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:05:35');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:06:20');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:07:31');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:08:38');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:09:26');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:10:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:11:42');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 07:12:27');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:13:38');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:14:22');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:15:31');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:16:38');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:17:25');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:18:32');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:19:42');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:20:26');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:21:36');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:22:21');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:23:31');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:24:38');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:25:24');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 07:26:31');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:27:41');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:28:26');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 07:29:36');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:30:20');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:31:30');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:32:37');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:33:26');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:34:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:35:43');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:36:27');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:37:38');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:38:23');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:39:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:40:39');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:41:26');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:42:33');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:43:43');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:44:27');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 07:45:37');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:46:21');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:47:31');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:48:38');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 07:49:25');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:50:32');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:51:41');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:52:26');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 07:53:37');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:54:21');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:55:31');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 07:56:38');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:57:25');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 07:58:32');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 07:59:42');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:00:27');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:01:36');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:02:20');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:03:30');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:04:36');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:05:44');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:06:29');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:07:38');
    INSERT INTO mytable(Value,timestamp) VALUES (657,'2021-03-18 08:08:22');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:09:32');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:10:39');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:11:26');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:12:33');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:13:42');
    INSERT INTO mytable(Value,timestamp) VALUES (696,'2021-03-18 08:14:27');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:15:35');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:16:19');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:17:30');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:18:37');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:19:24');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:20:30');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:21:40');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:22:24');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:23:35');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:24:20');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:25:29');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:26:36');
    INSERT INTO mytable(Value,timestamp) VALUES (676,'2021-03-18 08:27:23');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:28:29');
    INSERT INTO mytable(Value,timestamp) VALUES (667,'2021-03-18 08:29:39');
    INSERT INTO mytable(Value,timestamp) VALUES (686,'2021-03-18 08:30:23');
    INSERT INTO mytable(Value,timestamp) VALUES (715,'2021-03-18 08:31:31');
    INSERT INTO mytable(Value,timestamp) VALUES (754,'2021-03-18 08:32:38');
    INSERT INTO mytable(Value,timestamp) VALUES (773,'2021-03-18 08:33:26');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 08:34:33');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:35:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:36:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:37:36');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 08:38:21');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:39:29');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:40:36');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:41:23');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 08:42:30');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:43:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:44:24');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 08:45:34');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:46:19');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:47:29');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:48:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:49:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:50:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:51:41');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:52:26');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 08:53:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:54:41');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:55:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:56:35');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 08:57:23');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 08:58:30');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 08:59:40');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:00:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:01:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:02:19');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:03:30');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:04:37');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:05:24');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:06:31');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:07:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:08:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:09:35');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:10:19');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:11:29');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:12:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:13:44');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:14:29');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:15:37');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 09:16:21');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:17:31');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:18:38');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:19:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:20:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:21:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:22:26');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:23:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:24:21');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:25:29');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:26:36');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 09:27:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:28:30');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:29:40');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:30:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:31:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:32:41');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:33:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:34:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:35:43');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:36:28');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:37:39');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:38:23');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:39:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:40:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:41:27');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 09:42:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:43:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:44:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:45:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:46:21');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:47:29');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:48:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:49:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:50:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:51:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:52:24');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:53:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:54:41');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:55:28');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 09:56:35');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 09:57:22');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:58:29');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 09:59:39');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:00:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:01:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:02:40');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:03:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:04:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:05:43');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:06:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:07:38');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:08:22');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 10:09:32');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:10:39');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:11:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:12:33');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:13:43');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 10:14:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:15:35');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:16:20');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:17:30');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 10:18:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:19:24');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:20:31');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:21:41');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:22:25');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 10:23:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:24:40');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 10:25:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:26:34');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:27:44');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:28:28');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:29:38');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:30:22');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:31:32');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:32:39');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:33:26');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:34:33');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:35:44');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:36:28');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:37:38');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:38:22');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:39:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:40:39');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:41:25');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:42:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:43:41');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 10:44:26');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:45:34');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:46:42');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 10:47:29');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:48:35');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:49:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:50:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:51:38');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:52:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:53:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:54:39');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 10:55:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:56:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 10:57:44');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 10:58:28');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 10:59:38');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 11:00:22');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:01:33');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:02:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:03:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:04:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:05:43');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:06:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:07:38');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:08:22');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:09:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:10:37');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:11:25');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:12:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:13:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:14:26');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:15:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:16:20');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 11:17:30');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:18:37');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:19:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:20:32');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:21:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:22:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:23:35');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 11:24:20');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:25:30');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 11:26:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:27:24');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:28:31');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:29:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:30:26');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:31:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:32:21');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:33:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:34:39');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:35:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:36:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:37:42');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:38:27');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:39:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:40:21');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:41:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:42:37');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 11:43:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:44:32');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:45:41');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:46:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:47:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 11:48:20');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:49:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:50:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:51:24');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:52:31');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:53:42');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:54:27');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:55:35');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:56:20');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 11:57:30');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 11:58:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 11:59:24');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:00:31');

    Dato mínimo = 667    ,     '2021-03-18 08:29:39'

    Dato maximo = 831   ,     '2021-03-18 08:34:33'

    Se lo agradecería si me pudieran ayudar con una solución ante tanta fluctuación 


    Pregunta

    miércoles, 31 de marzo de 2021 4:46

Todas las respuestas

  • INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:01:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:02:27');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 12:03:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:04:20');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:05:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:06:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:07:24');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:08:31');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 12:09:40');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:10:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:11:35');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:12:19');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 12:13:29');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:14:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:15:23');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:16:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:17:38');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:18:23');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:19:33');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:20:39');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:21:27');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:22:34');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:23:42');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:24:27');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:25:35');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:26:20');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:27:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:28:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:29:24');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 12:30:31');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:31:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:32:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:33:35');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:34:20');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:35:30');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:36:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:37:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:38:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:39:43');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:40:27');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:41:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:42:22');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:43:31');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:44:39');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:45:26');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:46:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:47:43');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:48:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:49:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:50:22');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:51:31');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:52:38');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:53:25');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:54:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 12:55:43');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 12:56:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:57:36');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 12:58:21');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 12:59:32');

    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:00:39');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:01:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:02:33');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:03:42');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:04:27');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:05:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:06:21');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:07:31');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:08:37');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:09:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:10:30');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:11:40');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:12:25');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:13:34');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:14:41');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 13:15:29');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:16:36');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:17:23');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:18:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:19:40');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:20:24');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:21:34');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:22:41');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:23:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:24:35');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:25:43');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:26:28');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:27:39');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:28:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:29:31');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:30:38');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:31:25');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:32:32');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:33:42');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:34:26');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:35:36');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:36:20');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:37:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:38:37');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:39:24');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:40:31');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:41:40');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:42:25');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:43:35');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:44:42');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:45:29');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:46:36');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:47:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:48:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:49:38');
    INSERT INTO mytable(Value,timestamp) VALUES (860,'2021-03-18 13:50:23');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:51:34');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:52:41');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:53:28');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 13:54:35');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:55:23');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:56:30');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:57:39');
    INSERT INTO mytable(Value,timestamp) VALUES (841,'2021-03-18 13:58:23');
    INSERT INTO mytable(Value,timestamp) VALUES (831,'2021-03-18 13:59:32');
    INSERT INTO mytable(Value,timestamp) VALUES (850,'2021-03-18 14:00:39');


    Pregunta

    miércoles, 31 de marzo de 2021 4:48