这是表内容 我想要按rq分组,获取每组中mint最小的那一条数据,该如何做?
以下是实验数据::
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-24 08:30:00', 1349.04, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (0, '2019-12-16 08:30:00', 1034.16, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-19 08:30:00', 1149.84, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (0, '2019-12-20 08:30:00', 1190.13, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-23 08:30:00', 1308.88, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (0, '2019-12-17 08:30:00', 1073.98, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-12 08:30:00', 899.31, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (0, '2019-12-13 08:30:00', 916.79, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-22 08:30:00', 1269.3, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (0, '2019-12-21 08:30:00', 1230.12, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (0, '2019-12-18 08:30:00', 1113.18, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-21 08:25:00', 1229.98, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-17 08:35:00', 1074.12, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-19 08:35:00', 1149.97, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-21 08:35:00', 1230.26, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-13 08:35:00', 916.93, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-13 08:25:00', 916.65, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-23 08:35:00', 1309.03, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-23 08:25:00', 1308.75, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-24 08:25:00', 1348.91, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-20 08:35:00', 1190.26, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-18 08:35:00', 1113.31, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-22 08:25:00', 1269.16, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-12 08:25:00', 899.3, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-12 08:35:00', 899.32, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-18 08:25:00', 1113.06, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-14 08:25:00', 955.3, '2019-12-14');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-17 08:25:00', 1073.84, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-20 08:25:00', 1189.99, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-16 08:25:00', 1034.02, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-15 08:35:00', 995.01, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-19 08:25:00', 1149.7, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (5, '2019-12-22 08:35:00', 1269.44, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (5, '2019-12-24 08:35:00', 1349.17, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-19 08:20:00', 1149.57, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-20 08:40:00', 1190.39, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-17 08:40:00', 1074.25, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-23 08:20:00', 1308.61, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-13 08:40:00', 917.08, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-22 08:20:00', 1269.03, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-16 08:20:00', 1033.87, '2019-12-16');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-19 08:40:00', 1150.12, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-21 08:40:00', 1230.4, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-20 08:20:00', 1189.85, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-18 08:40:00', 1113.43, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-22 08:40:00', 1269.59, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-21 08:20:00', 1229.84, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-12 08:20:00', 899.29, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-12 08:40:00', 899.33, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-17 08:20:00', 1073.83, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-18 08:20:00', 1112.91, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-24 08:20:00', 1348.78, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-23 08:40:00', 1309.18, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (10, '2019-12-13 08:20:00', 916.52, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (10, '2019-12-24 08:40:00', 1349.3, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-17 08:15:00', 1073.56, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-22 08:45:00', 1269.73, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-24 08:45:00', 1349.45, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-21 08:45:00', 1230.55, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-13 08:15:00', 916.38, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-20 08:15:00', 1189.72, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-19 08:45:00', 1150.27, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-17 08:45:00', 1074.39, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-21 08:15:00', 1229.71, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-16 08:45:00', 1034.56, '2019-12-16');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-16 08:15:00', 1033.74, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-15 08:15:00', 994.46, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-18 08:15:00', 1112.77, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-19 08:15:00', 1149.43, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-20 08:45:00', 1190.53, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-23 08:15:00', 1308.47, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-12 08:15:00', 899.28, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-12 08:45:00', 899.34, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-22 08:15:00', 1268.91, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-23 08:45:00', 1309.33, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-13 08:45:00', 917.21, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (15, '2019-12-18 08:45:00', 1113.56, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (15, '2019-12-24 08:15:00', 1348.65, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-13 08:50:00', 917.33, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-24 08:50:00', 1349.59, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-16 08:10:00', 1033.59, '2019-12-16');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-20 08:10:00', 1189.6, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-18 08:10:00', 1112.62, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-22 08:10:00', 1268.79, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-21 08:50:00', 1230.7, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-23 08:10:00', 1308.32, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-19 08:50:00', 1150.42, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-22 08:50:00', 1269.89, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-15 08:10:00', 994.3, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-17 08:50:00', 1074.54, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-21 08:10:00', 1229.58, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-16 08:50:00', 1034.7, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-17 08:10:00', 1073.43, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-24 08:10:00', 1348.52, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-12 08:10:00', 899.27, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-12 08:50:00', 899.35, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-20 08:50:00', 1190.68, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-13 08:10:00', 916.25, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-23 08:50:00', 1309.48, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-18 08:50:00', 1113.71, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (20, '2019-12-14 08:10:00', 954.84, '2019-12-14');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (20, '2019-12-19 08:10:00', 1149.29, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-20 08:55:00', 1190.82, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-15 08:05:00', 994.17, '2019-12-15');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-18 08:55:00', 1113.85, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-22 08:55:00', 1270.03, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-19 08:05:00', 1149.16, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-17 08:55:00', 1074.69, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-20 08:05:00', 1189.47, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-22 08:05:00', 1268.66, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-13 08:05:00', 916.14, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-21 08:55:00', 1230.83, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-24 08:05:00', 1348.39, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-23 08:55:00', 1309.64, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-19 08:55:00', 1150.57, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-16 08:05:00', 1033.45, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-24 08:55:00', 1349.73, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-12 08:05:00', 899.26, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-12 08:55:00', 899.36, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-18 08:05:00', 1112.49, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-13 08:55:00', 917.45, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-17 08:05:00', 1073.29, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-21 08:05:00', 1229.44, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (25, '2019-12-16 08:55:00', 1034.83, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (25, '2019-12-23 08:05:00', 1308.17, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-16 08:00:00', 1033.33, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-23 08:00:00', 1308.01, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-17 09:00:00', 1074.83, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-20 09:00:00', 1190.98, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-21 08:00:00', 1229.3, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-15 08:00:00', 994.04, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-21 09:00:00', 1230.96, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-18 08:00:00', 1112.37, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-23 09:00:00', 1309.8, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-19 09:00:00', 1150.71, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-22 08:00:00', 1268.54, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-18 09:00:00', 1114, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-20 08:00:00', 1189.33, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-24 09:00:00', 1349.86, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-12 08:00:00', 899.25, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-22 09:00:00', 1270.16, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-24 08:00:00', 1348.25, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-13 09:00:00', 917.58, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-13 08:00:00', 916.02, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-16 09:00:00', 1034.98, '2019-12-16');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (30, '2019-12-19 08:00:00', 1149.02, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (30, '2019-12-17 08:00:00', 1073.16, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-18 07:55:00', 1112.25, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-18 09:05:00', 1114.14, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-24 09:05:00', 1349.99, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-13 09:05:00', 917.72, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-17 07:55:00', 1073.03, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-15 07:55:00', 993.91, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-20 07:55:00', 1189.2, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-21 07:55:00', 1229.16, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-23 07:55:00', 1307.86, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-22 09:05:00', 1270.29, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-16 09:05:00', 1035.11, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-17 09:05:00', 1074.97, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-20 09:05:00', 1191.13, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-19 09:05:00', 1150.85, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-24 07:55:00', 1348.12, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-12 07:55:00', 899.24, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-22 07:55:00', 1268.4, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-13 07:55:00', 915.9, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-21 09:05:00', 1231.08, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-19 07:55:00', 1148.88, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (35, '2019-12-23 09:05:00', 1309.96, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (35, '2019-12-16 07:55:00', 1033.21, '2019-12-16');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-15 09:10:00', 996.03, '2019-12-15');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-24 07:50:00', 1347.99, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-23 07:50:00', 1307.71, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-17 07:50:00', 1072.89, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-13 09:10:00', 917.87, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-13 07:50:00', 915.77, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-18 09:10:00', 1114.29, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-20 09:10:00', 1191.26, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-16 09:10:00', 1035.26, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-24 09:10:00', 1350.11, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-19 07:50:00', 1148.74, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-17 09:10:00', 1075.11, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-18 07:50:00', 1112.13, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-15 07:50:00', 993.79, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-22 07:50:00', 1268.26, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-23 09:10:00', 1310.12, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-16 07:50:00', 1033.09, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-21 07:50:00', 1229.03, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-12 07:50:00', 899.22, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-22 09:10:00', 1270.42, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-19 09:10:00', 1151, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (40, '2019-12-21 09:10:00', 1231.22, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (40, '2019-12-20 07:50:00', 1189.06, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-17 09:15:00', 1075.24, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-17 07:45:00', 1072.75, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-15 07:45:00', 993.66, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-19 07:45:00', 1148.6, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-21 09:15:00', 1231.36, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-23 07:45:00', 1307.57, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-18 07:45:00', 1111.99, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-18 09:15:00', 1114.43, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-15 09:15:00', 996.08, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-19 09:15:00', 1151.12, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-20 07:45:00', 1188.92, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-21 07:45:00', 1228.9, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-22 07:45:00', 1268.14, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-22 09:15:00', 1270.55, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-12 07:45:00', 899.2, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-24 09:15:00', 1350.23, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-13 09:15:00', 918, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-13 07:45:00', 915.65, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-16 07:45:00', 1032.96, '2019-12-16');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-20 09:15:00', 1191.39, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (45, '2019-12-24 07:45:00', 1347.88, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (45, '2019-12-23 09:15:00', 1310.28, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-23 07:40:00', 1307.42, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-23 09:20:00', 1310.43, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-17 09:20:00', 1075.36, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-13 09:20:00', 918.13, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-13 07:40:00', 915.51, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-17 07:40:00', 1072.61, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-19 09:20:00', 1151.25, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-18 09:20:00', 1114.55, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-20 07:40:00', 1188.78, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-12 07:40:00', 899.15, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-18 07:40:00', 1111.84, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-22 09:20:00', 1270.68, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-24 09:20:00', 1350.37, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-24 07:40:00', 1347.75, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-21 09:20:00', 1231.49, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-22 07:40:00', 1268.01, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-21 07:40:00', 1228.78, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-20 09:20:00', 1191.52, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-15 07:40:00', 993.52, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (50, '2019-12-16 07:40:00', 1032.83, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (50, '2019-12-19 07:40:00', 1148.46, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-20 07:35:00', 1188.63, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-23 09:25:00', 1310.57, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-20 09:25:00', 1191.66, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-21 07:35:00', 1228.65, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-18 07:35:00', 1111.7, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-24 07:35:00', 1347.64, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-21 09:25:00', 1231.64, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-14 07:35:00', 953.93, '2019-12-14');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-19 07:35:00', 1148.32, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-23 07:35:00', 1307.27, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-17 07:35:00', 1072.47, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-22 09:25:00', 1270.82, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-12 07:35:00', 899.06, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-19 09:25:00', 1151.39, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-17 09:25:00', 1075.5, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-13 09:25:00', 918.24, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-13 07:35:00', 915.37, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-18 09:25:00', 1114.67, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-16 07:35:00', 1032.69, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-15 07:35:00', 993.39, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (55, '2019-12-24 09:25:00', 1350.5, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (55, '2019-12-22 07:35:00', 1267.88, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-24 07:30:00', 1347.51, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-20 07:30:00', 1188.48, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-14 07:30:00', 953.79, '2019-12-14');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-22 09:30:00', 1270.96, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-13 09:30:00', 918.36, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-13 07:30:00', 915.24, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-24 09:30:00', 1350.64, '2019-12-24');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-21 07:30:00', 1228.52, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-20 09:30:00', 1191.8, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-17 07:30:00', 1072.33, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-23 07:30:00', 1307.11, '2019-12-23');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-21 09:30:00', 1231.78, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-16 07:30:00', 1032.54, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-15 07:30:00', 993.24, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-18 07:30:00', 1111.56, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-23 09:30:00', 1310.71, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-19 07:30:00', 1148.18, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-12 07:30:00', 898.95, '2019-12-12');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-22 07:30:00', 1267.74, '2019-12-22');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-19 09:30:00', 1151.54, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (60, '2019-12-17 09:30:00', 1075.65, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (60, '2019-12-18 09:30:00', 1114.8, '2019-12-18');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-17 07:25:00', 1072.19, '2019-12-17');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-22 09:35:00', 1271.11, '2019-12-22');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-20 09:35:00', 1191.94, '2019-12-20');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-17 09:35:00', 1075.8, '2019-12-17');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-14 07:25:00', 953.63, '2019-12-14');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-15 07:25:00', 993.09, '2019-12-15');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-16 07:25:00', 1032.41, '2019-12-16');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-20 07:25:00', 1188.34, '2019-12-20');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-18 07:25:00', 1111.41, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-24 07:25:00', 1347.37, '2019-12-24');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-21 09:35:00', 1231.93, '2019-12-21');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-23 09:35:00', 1310.85, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-12 07:25:00', 898.84, '2019-12-12');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-19 09:35:00', 1151.69, '2019-12-19');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-19 07:25:00', 1148.03, '2019-12-19');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-21 07:25:00', 1228.38, '2019-12-21');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-13 09:35:00', 918.5, '2019-12-13');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-13 07:25:00', 915.11, '2019-12-13');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-18 09:35:00', 1114.94, '2019-12-18');
INSERT INTO (`mint`, `collectionTime`, `kwh`, `rq`) VALUES (65, '2019-12-23 07:25:00', 1306.96, '2019-12-23');
(
INSERT INTOmint
, collectionTime
, kwh
, rq
) VALUES (65, '2019-12-22 07:25:00', 1267.6, '2019-12-22');
MYSQL GROUP BY 获取最小条目
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
4条回答 默认 最新
悬赏问题
- ¥20 删除和修改功能无法调用
- ¥15 kafka topic 所有分副本数修改
- ¥15 小程序中fit格式等运动数据文件怎样实现可视化?(包含心率信息))
- ¥15 如何利用mmdetection3d中的get_flops.py文件计算fcos3d方法的flops?
- ¥40 串口调试助手打开串口后,keil5的代码就停止了
- ¥15 电脑最近经常蓝屏,求大家看看哪的问题
- ¥60 高价有偿求java辅导。工程量较大,价格你定,联系确定辅导后将采纳你的答案。希望能给出完整详细代码,并能解释回答我关于代码的疑问疑问,代码要求如下,联系我会发文档
- ¥50 C++五子棋AI程序编写
- ¥30 求安卓设备利用一个typeC接口,同时实现向pc一边投屏一边上传数据的解决方案。
- ¥15 SQL Server analysis services 服务安装失败