基本表结构

/*Navicat Premium Data TransferSource Server         : mylifeSource Server Type    : MySQLSource Server Version : 50528Source Host           : localhost:3306Source Schema         : testTarget Server Type    : MySQLTarget Server Version : 50528File Encoding         : 65001Date: 30/07/2021 10:31:25
*/SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;-- ----------------------------
-- Table structure for stu
-- ----------------------------
DROP TABLE IF EXISTS `stu`;
CREATE TABLE `stu`  (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`pass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`time` datetime NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;-- ----------------------------
-- Records of stu
-- ----------------------------
INSERT INTO `stu` VALUES (1, 'zs', '123', '2021-07-30 09:10:51');
INSERT INTO `stu` VALUES (2, 'ls', '123', '2021-07-13 09:10:58');
INSERT INTO `stu` VALUES (3, 'zs', '123', '2020-06-30 09:11:02');
INSERT INTO `stu` VALUES (4, 'ls', 're', '2021-05-26 09:11:09');SET FOREIGN_KEY_CHECKS = 1;

SQL语句

select *from 
(select *from stu order by time)
as new_tbl 
group by name;