DROP TABLE IF EXISTS `teamtb`;
CREATE TABLE `teamtb` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`teamid` INT(11) DEFAULT NULL,
`name` VARCHAR(20) DEFAULT NULL,
`paytime` DATETIME DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;INSERT INTO teamtb(teamid,NAME,paytime)
VALUES
(6,'小明',NOW()),
(6,'小王',ADDDATE(NOW(),INTERVAL -1 DAY)),
(8,'小张',ADDDATE(NOW(),INTERVAL -2 DAY)),
(8,'小李',ADDDATE(NOW(),INTERVAL -1 DAY))SELECT teamid,MAX(paytime) FROM teamtb GROUP BY teamid ORDER BY paytime DESC
CREATE TABLE `teamtb` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`teamid` INT(11) DEFAULT NULL,
`name` VARCHAR(20) DEFAULT NULL,
`paytime` DATETIME DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;INSERT INTO teamtb(teamid,NAME,paytime)
VALUES
(6,'小明',NOW()),
(6,'小王',ADDDATE(NOW(),INTERVAL -1 DAY)),
(8,'小张',ADDDATE(NOW(),INTERVAL -2 DAY)),
(8,'小李',ADDDATE(NOW(),INTERVAL -1 DAY))SELECT teamid,MAX(paytime) FROM teamtb GROUP BY teamid ORDER BY paytime DESC
order by 不用也可以
忘记用MAX()这个函数了 一个劲的排序 分组