mysql 查询其他字段相同，某个字段最大的一条数据

最新推荐文章于 2024-04-25 12:02:52 发布

VIP文章我爱卷粉

最新推荐文章于 2024-04-25 12:02:52 发布

阅读量4.1k

点赞数

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/qq_42319677/article/details/121512323

版权

创建表：


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for worktime
-- ----------------------------
DROP TABLE IF EXISTS `worktime`;
CREATE TABLE `worktime`  (
  `userId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `createTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  `projectId` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目id',
  `fileName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `time` int(11) NULL DEFAULT NULL COMMENT '工时'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of worktime
-- ----------------------------