mysql - 获取最近 10 分钟数据的唯一值 - mysql

Question

<小时/>

--data2的表结构

<小时/>

DROP TABLE IF EXISTS `data2`;
CREATE TABLE `data2` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `DTIME` datetime DEFAULT NULL,
  `NUM` int(10) DEFAULT NULL,
  `VALUE` int(10) DEFAULT NULL,
  `REF` int(10) DEFAULT NULL,
  `NOD` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2033 DEFAULT CHARSET=latin1;

<小时/>

--数据记录2

<小时/>

INSERT INTO `data2` VALUES ('2015', '2014-02-07 00:05:00', '120', '1491900', '1', 'AA');
INSERT INTO `data2` VALUES ('2016', '2014-02-07 00:10:00', '120', '1491901', '1', 'AA');
INSERT INTO `data2` VALUES ('2017', '2014-02-07 00:15:00', '120', '1491902', '1', 'AA');
INSERT INTO `data2` VALUES ('2018', '2014-02-07 00:05:00', '120', '1491903', '1', 'BB');
INSERT INTO `data2` VALUES ('2019', '2014-02-07 00:15:00', '120', '1491904', '1', 'BB');
INSERT INTO `data2` VALUES ('2020', '2014-02-07 00:05:00', '120', '1491905', '1', 'BB');
INSERT INTO `data2` VALUES ('2021', '2014-02-07 00:10:00', '200', '1491906', '1', 'CC');
INSERT INTO `data2` VALUES ('2022', '2014-02-07 00:15:00', '200', '1491907', '1', 'CC');
INSERT INTO `data2` VALUES ('2023', '2014-02-07 00:05:00', '200', '1491908', '1', 'CC');
INSERT INTO `data2` VALUES ('2024', '2014-02-07 00:15:00', '200', '1491909', '1', 'AA');
INSERT INTO `data2` VALUES ('2025', '2014-02-07 00:05:00', '200', '1491910', '1', 'AA');
INSERT INTO `data2` VALUES ('2026', '2014-02-07 00:10:00', '200', '1491911', '1', 'AA');
INSERT INTO `data2` VALUES ('2027', '2014-02-07 00:15:00', '800', '1491912', '1', 'AA');
INSERT INTO `data2` VALUES ('2028', '2014-02-07 00:05:00', '800', '1491913', '1', 'AA');
INSERT INTO `data2` VALUES ('2029', '2014-02-07 00:15:00', '800', '1491914', '1', 'BB');
INSERT INTO `data2` VALUES ('2030', '2014-02-07 00:05:00', '800', '1491915', '1', 'BB');
INSERT INTO `data2` VALUES ('2031', '2014-02-07 00:10:00', '800', '1491916', '1', 'BB');
INSERT INTO `data2` VALUES ('2032', '2014-02-07 00:15:00', '800', '2120449', '0', 'BB');

我上面有样本数据，我想要的是获取唯一 NUM-NOD 数据的最新数据。如何仅使用 mysql 查询获取以下输出

'2014-2-7 00:15:00',120,1491902, 1,'AA'
'2014-2-7 00:15:00',120,1491904, 1,'BB'
'2014-2-7 00:15:00',200,1491907, 1,'CC'
'2014-2-7 00:15:00',200,1491909, 1,'AA'
'2014-2-7 00:15:00',800,1491912, 1,'AA'
'2014-2-7 00:15:00',800,2120449, 0,'BB'

每个 NOD 每 5 分钟就会添加一次新数据，但有时某些 NOD 的数据会延迟(所有 NOD 的最后日期时间数据并不总是相同)

Answer 1

尝试

SELECT DISTINCT *
FROM data2
WHERE DTIME > '2014-02-07 00:10:00'
ORDER BY DTIME DESC

SQLFIDDLE