主页 / 问题 / 1201998
Accepted
YevgeniyM
Asked:2021-11-09 13:06:18 +0800 CST2021-11-09 13:06:18 +0800 CST

选择最大 mysql 值

  • 772
CREATE TABLE `incoming` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dt_first` datetime DEFAULT NULL,
  `dt_second` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

您需要选择日期差异之间最大值的 id：

MAX(unix_timestamp(dt_first)-unix_timestamp(dt_second))
mysql

1 个回答

  1. Best Answer
    SELECT id
FROM incoming
ORDER BY TIMESTAMPDIFF(SECOND, dt_first, dt_second) DESC
LIMIT 1
    • 1

相关问题