mysql分组查询最近的一条数据

最新推荐文章于 2024-07-25 19:14:08 发布
最新推荐文章于 2024-07-25 19:14:08 发布
阅读量898 收藏
点赞数
文章标签： mysql 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45352783/article/details/122975956
版权 

DROP TABLE IF EXISTS `jt_mes_monitoring`;
CREATE TABLE `jt_mes_monitoring`  (
  `mes_id` bigint(30) NOT NULL COMMENT '消息ID',
  `old_id` int(10) NULL DEFAULT NULL COMMENT '老人ID',
  `old_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '老人姓名',
  `receiving_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警时间',
  `main_device_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主机设备ID',
  `device_sn` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备sn编码',
  `device_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
  `device_type` int(10) NULL DEFAULT NULL COMMENT '设备类型',
  `device_state` int(10) NULL DEFAULT NULL COMMENT '设备状态',
  `device_state_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警信息',
  `mattress_state` int(2) NULL DEFAULT NULL COMMENT '床垫状态：0：表示在床；1：表示离床；2：体动；3：表示弱呼吸 4：表示重物；5：表示打鼾；',
  `heart_rate` int(10) NULL DEFAULT NULL COMMENT '心跳',
  `respiratory_rate` int(10) NULL DEFAULT NULL COMMENT '呼吸',
  `danger_grade` int(1) NULL DEFAULT NULL COMMENT '告警级别 1:提醒 2:紧急',
  `danger_type` int(1) NULL DEFAULT NULL COMMENT '预警类型 1:安全预警 2:烟感预警 3:燃气预警 4:SOS预警',
  `deal_state` int(1) NULL DEFAULT NULL COMMENT '状态 1:待处理 2:已处理',
  `deal_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '处理内容',
  `deal_photo` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '处理图片',
  `deal_video` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '处理音视频',
  `deal_people` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理人',
  `deal_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理时间',
  `del_flag` int(1) NULL DEFAULT NULL COMMENT '删除标记 0:正常 2:已删除',
  `create_user` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  `update_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `update_time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`mes_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '信息管理' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of jt_mes_monitoring
-- ----------------------------
INSERT INTO `jt_mes_monitoring` VALUES (912760337902399488, 96738, 'xxx', '2021-11-23 15:04:56', 'MBT1DA5C5C802710', '020090122', '门磁监测器', 1001, 1000, '门打开', NULL, 0, 0, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-23 17:43:47', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (912760440801259520, 96738, 'xxx', '2021-11-16 11:02:44', 'MBT1DA5C5C802710', '010014145', 'SOS无线呼叫器', 1013, 1000, 'SOS报警', NULL, 0, 0, 2, 4, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-23 17:44:08', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (912991152087298048, 96738, 'xxx', '2021-11-23 15:04:57', 'MBT1DA5C5C802710', '020090122', '门磁监测器', 1001, 1000, '门打开', NULL, 0, 0, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:00:59', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (912991317338681344, 96738, 'xxx', '2021-11-23 15:12:21', 'MBT1DA5C5C802710', '020090122', '门磁监测器', 1001, 1200, '门关上', NULL, 0, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:01:33', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (912992749676720128, 96738, 'xxx', '2021-11-23 15:31:45', 'MBT1DA5C5C802710', '070012206', '烟感监测器', 1003, 1000, '烟感报警', NULL, 0, 0, 2, 2, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:07:15', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (912993619084636160, 96738, 'xxx', '2021-11-23 15:37:32', 'MBT1DA5C5C802710', '160004251', '燃气监测器', 1004, 1000, '燃气报警', NULL, 0, 0, 2, 3, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:10:42', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (912993733572358144, 96738, 'xxx', '2021-11-23 15:39:55', 'MBT1DA5C5C802710', '052135080', '人体活动监测器', 1002, 1000, '人员经过', NULL, 0, 0, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:11:09', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001132987314176, 96738, 'xxx', '2021-11-24 09:04:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:40:34', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001232413290496, 96738, 'xxx', '2021-11-24 09:05:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:40:57', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001268186509312, 96738, 'xxx', '2021-11-24 09:06:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 81, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:06', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001297827655680, 96738, 'xxx', '2021-11-24 09:07:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 71, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:13', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001328269914112, 96738, 'xxx', '2021-11-24 09:08:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 66, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:20', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001360146624512, 96738, 'xxx', '2021-11-24 09:09:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 68, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:28', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001396540600320, 96738, 'xxx', '2021-11-24 09:10:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 81, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:36', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001430095032320, 96738, 'xxx', '2021-11-24 09:11:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 83, 23, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:44', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001465062944768, 96738, 'xxx', '2021-11-24 09:12:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 85, 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:41:53', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001630792478720, 96738, 'xxx', '2021-11-24 09:13:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 90, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:42:32', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001657615052800, 96738, 'xxx', '2021-11-24 09:14:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 84, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:42:39', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001692926898176, 96738, 'xxx', '2021-11-24 09:15:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 81, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:42:47', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001720810631168, 96738, 'xxx', '2021-11-24 09:16:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 77, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:42:54', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001746664321024, 96738, 'xxx', '2021-11-24 09:17:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 77, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:43:00', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001792378040320, 96738, 'xxx', '2021-11-24 09:18:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 76, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:43:11', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001820236607488, 96738, 'xxx', '2021-11-24 09:19:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 79, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:43:18', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001890243735552, 96738, 'xxx', '2021-11-24 09:20:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 81, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:43:34', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001942735450112, 96738, 'xxx', '2021-11-24 09:21:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 78, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:43:47', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913001975547490304, 96738, 'xxx', '2021-11-24 09:22:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 80, 18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:43:55', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002002059685888, 96738, 'xxx', '2021-11-24 09:23:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 81, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:44:01', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002438648983552, 96738, 'xxx', '2021-11-24 09:24:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 82, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:45:45', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002465739993088, 96738, 'xxx', '2021-11-24 09:25:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 62, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:45:51', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002492591927296, 96738, 'xxx', '2021-11-24 09:26:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 52, 13, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:45:58', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002518986682368, 96738, 'xxx', '2021-11-24 09:27:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 51, 11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:46:04', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002554965422080, 96738, 'xxx', '2021-11-24 09:28:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 48, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:46:13', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002584958889984, 96738, 'xxx', '2021-11-24 09:29:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 48, 14, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:46:20', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913002615757664256, 96738, 'xxx', '2021-11-24 09:30:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '在床', 0, 49, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:46:27', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913003518782926848, 96738, 'xxx', '2021-11-24 09:31:23', 'MBT1DA5C5C802710', '000000021', '睡眠监测带', 1050, 0, '在床', 0, 49, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:50:02', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913003546503081984, 96738, 'xxx', '2021-11-24 09:32:23', 'MBT1DA5C5C802710', '000000021', '睡眠监测带', 1050, 0, '在床', 0, 50, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:50:09', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913003574244208640, 96738, 'xxx', '2021-11-24 09:33:23', 'MBT1DA5C5C802710', '000000021', '睡眠监测带', 1050, 0, '离床', 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:50:16', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913003605533716480, 96738, 'xxx', '2021-11-24 09:34:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '离床', 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:50:23', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913003663553523712, 96738, 'xxx', '2021-11-24 09:35:23', 'MBT1DA5C5C802710', '000000021', '睡眠监测带', 1050, 0, '离床', 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:50:37', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913003690531287040, 96738, 'xxx', '2021-11-24 09:36:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '离床', 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-11-24 09:50:43', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (913095512251232256, 96738, 'xxx', '2021-11-24 09:42:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '呼吸过缓  ', 0, 50, 10, 2, 1, 2, '8', 'http://192.168.1.213:8999/web/091c27.jpg', 'http://192.168.1.213:8999/web/ab896e.mp4', NULL, NULL, 0, NULL, '2021-11-24 15:55:36', NULL, '2021-11-26 14:14:01');
INSERT INTO `jt_mes_monitoring` VALUES (913097870280552448, 96738, 'xxx', '2021-11-24 09:42:23', 'MBT1DA5C5C802710', '000000020', '睡眠监测带', 1050, 0, '呼吸过缓  ', 0, 50, 10, 2, 1, 2, '5555', 'http://192.168.1.213:8999/web/128308.jpg', 'http://192.168.1.213:8999/web/2730cc.mp4', NULL, NULL, 0, NULL, '2021-11-24 16:04:58', NULL, '2021-11-26 14:09:27');
INSERT INTO `jt_mes_monitoring` VALUES (915625526607802368, NULL, NULL, '2021-11-23 15:39:28', 'MBT1DA5C5C802710', '052135080', '人体活动监测器', 1002, 1000, '人员经过', 0, 0, 0, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-12-01 15:28:57', NULL, NULL);
INSERT INTO `jt_mes_monitoring` VALUES (915632361737875456, NULL, NULL, '2021-12-01 15:55:51', 'MBT1DA5C5C802710', '010014145', 'SOS无线呼叫器', 1013, 1000, 'SOS报警', 0, 0, 0, 2, 4, 1, NULL, NULL, NULL, NULL, NULL, 0, NULL, '2021-12-01 15:56:14', NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;


SELECT
	* 
FROM
	jt_mes_monitoring 
WHERE
	create_time IN ( SELECT max( create_time ) FROM jt_mes_monitoring where mattress_state in (1,2) GROUP BY device_sn )
	and device_type =1050

先分组查询最近的时间

不吃糯玉米
关注
Mysql分组查询获取每组最新一条数据
weixin_42286461的博客
08-20 8560
Mysql分组查询获取每组最新一条数据
mysql分组查询选择数量最多的前十个_MySQL分组查询前几条数据
weixin_33410492的博客
02-08 2817
分组查询是一个比较常见也稍微复杂一点的查询，好比查询每一个班成绩最好的三名学生，每一个部门工资最高的三个员工等等，今天就分享一下分组查询这样一个用法。sql1、准备工做首先上两张表，部门表和员工表。spa部门表codeDROP TABLE IF EXISTS `department`;CREATE TABLE `department` (`id` int(10) NOT NULL AUTO_INC...
Mysql查询最近一条记录的sql语句(优化篇)
09-09
主要介绍了Mysql查询最近一条记录的sql语句，非常不错，具有一定的参考借鉴价值，需要的朋友参考下吧
mysql如何查询最近的一条记录
空白_回忆的博客
07-18 1878
mysql如何查询最近的一条记录MySql : SELECT * FROM 表名 ORDER BY 表_ID DESC LIMIT 0,1
Mysql分组取最新一条数据总结（多种方法比较）
最新发布
weixin_43582896的博客
07-25 2545
在日常业务开发中涉及到报表的统计，或者取某一个用户最新的一条记录并对他进行业务分析等等，现总结了常见的几种方法去取这这一类数据这里以mysql 5.7为例子。
mysql 查询距离某天最近的一条记录
listen
04-22 5383
sql 的写法，查询出距离今天最近的那条记录 SELECT id,min(NOW()-updateTime) as time,`name` FROM dd GROUP BY id LIMIT 0,1 2.建表语句 DROP TABLE IF EXISTS `dd`; CREATE TABLE `dd` ( `id` int(11) NOT NULL, `name` va...
mysql 最近一条数据
讯达网络科技的博客
08-10 321
mysql 最近一条数据
【精】Mysql查询最近时间段的数据
【冯立雄】的博客
05-17 3533
函数 描述 NOW() 返回当前的日期和时间 CURDATE() 返回当前的日期 CURTIME() 返回当前的时间 DATE() 提取日期或日期/时间表达式的日期部分 EXTRACT() 返回日期/时间按的单独部分 DATE_ADD() 给日期添加指定的时间间隔 DATE_SUB() 从日期减去指定的时间间隔 DAT...
Mysql取分组后的每组第一条数据
12-14
然后在外部查询中，我们选取了每一组中`row_num = 1`的记录，即每组的最新一条数据。 需要注意的是，MySQL在某些情况下会创建临时表来处理复杂的查询，例如上述的子查询或者涉及`UNION`，`DISTINCT`，`ORDER BY`与`...
MySql分组后随机获取每组一条数据的操作
12-14
在MySQL数据库中，有时我们需要对数据进行分组处理，并从每个分组中随机选取一条记录。这在统计分析或者抽样调查等场景中非常常见。本文将详细介绍如何在MySQL中实现这一操作，以及一些关于随机选取数据的优化方法。...
优化mysql查找最新一条数据
weixin_38950807的博客
07-24 2405
title: 优化mysql查找最新一条数据 date: 2019-07-24 11:23:21 categories: 数据库 tags: MySql 今天写Web时，发现有个请求一直没有响应，用谷歌F12看了一下，请求出现了一个问题。 我第一反应是网络延迟，又试了几次，还是这个问题，便看了一下后台控制台也没报错，便想是不是sql查询时间太长了，便把sql手动运行了下，果然花了48s。...
mysql 查询当天、本周，本月，上一个月的数据
03-05
mysql 查询当天、本周，本月，上一个月的数据 今天 select * from 表名 where to_days(时间字段名) = to_days(now()); 昨天 SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) <= 1
mysql查询近几日之内的数据
weixin_45508572的博客
08-05 171
这里查询的是近一周的数据 例子: SELECT * FROM cnpc_employee WHERE cnpc_employee.status = 0 AND cnpc_employee.hose != '12356' and cnpc_employee.on_job = #{onJob} and DATE_SUB(CURDATE(), INTERVAL 7 DAY) <![CDATA[ <= ]]> date(departure_time) 注意:7
使用mysql查询当天、近一周、近一个月及近一年的数据以及各种报表查询sql
qq_37557563的博客
01-05 8759
查询各种数据报表sql写法
[mysql]分组取Top n、最近一条
liuhe2296044的博客
11-10 8939
一直没有时间写分享，终于等到双十一，任何需求都不准上，这才抽出时间整理一下搜集了好几天的SQL。 需求：查出用户最近一条登录记录。(110w条） 前提：默认时间和id都是递增。（求时间最大-&gt;求id最大） 第一种：select * from user_login_log where id in(select max(id) from user_login_log group b...
mysql-获取某个时间段的最近一条数据
rclack的博客
08-10 3964
一 来源 我需要获取rating_date最近的一条数据 select * from rating_basic_info WHERE company_id = 11501 order by abs(datediff(rating_date,'2020-08-03')) asc limit 1,1 效果图： 上面是代码 select * from rating_basic_info WHERE company_id = 11501 order by abs(datedif...
mysql+查询新的一条记录表,mysql 查询不同用户 最新的一条记录
weixin_42305377的博客
03-23 546
数据库记录: MYSQL查询不同用户 最新的一条记录方法1：查询出结果后将时间排序后取第一条(只能取到一条，并且不能查询不同客户的记录)SELECT CUSTOMER_ID,CONTENT,MODIFY_TIME FROM `service_records` ORDER BY MODIFY_TIME DESC LIMIT 1;查询结果: 方法2：查询排序后group by(先按照MODIFY_TI...
怎样显示mysql数据库的最后一条记录
热门推荐
胆大心细，乃成大事要素之一
05-26 1万+
select   *   from   table   order   by   id   desc   limit   1
MySQL分组查询每组最新的一条数据
07-27
以下是一个示例的MySQL查询语句： ``` SELECT t1.* FROM your_table t1 JOIN ( SELECT MAX(timestamp_column) AS max_timestamp FROM your_table GROUP BY group_column ) t2 ON t1.group_column = t2.group_...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值