查询每天最新时间的数据

最新推荐文章于 2024-07-30 20:07:10 发布

照亮自己的发光体

最新推荐文章于 2024-07-30 20:07:10 发布

阅读量69

点赞数

文章标签： java 前端 javascript

本文链接：https://blog.csdn.net/weixin_48141625/article/details/132163703

版权

创建表

CREATE TABLE `title`  (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `industry` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '行业',
  `inCompanyName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '所在单位',
  `careerTitle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '原有职称',
  `duties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '职务',
  `disciplineCategories_PermissionCode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '学科门类',
  `level1Discipline` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '一级学科',
  `education_PermissionCode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '学位',
  `occupationalTitle_PermissionCode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '要申请的职称',
  `expertNumber` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '推荐专家编码',
  `applyIntroduce` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '申请说明',
  `applyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `appplyUserId` bigint NULL DEFAULT NULL COMMENT '申请用户的id',
  `status` bigint NULL DEFAULT 0 COMMENT '0是未审核，1是已经审核通过，2审核驳回，-1已取消申请',
  `examineUserId` bigint NULL DEFAULT NULL COMMENT '审核用户id',
  `examineTime` timestamp NULL DEFAULT NULL COMMENT '审核时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `id`(`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

向表中插入数据

INSERT INTO `apply_occupational_title` VALUES (1, '行业', '单位', '职称', '职务', '2', '一级', '4', '7', '123', '123', '2023-06-18 21:50:03', 2, 0, NULL, NULL);
INSERT INTO `apply_occupational_title` VALUES (2, '行业', '单位', '职称', '职务', '2', '一级', '4', '7', '123', '123', '2023-06-19 21:50:03', 2, 0, NULL, NULL);
INSERT INTO `apply_occupational_title` VALUES (3, '123', '123', '', '', '1', '123', '2', NULL, '', '', '2023-06-20 15:52:58', 1, 0, NULL, NULL);
INSERT INTO `apply_occupational_title` VALUES (4, '行业', '单位', '职称', '职务', '2', '一级', '4', '7', '123', '12333', '2023-06-20 23:16:05', 2, 0, NULL, NULL);
INSERT INTO `apply_occupational_title` VALUES (5, '行业', '单位', '职称', '职务', '2', '一级', '4', '7', '123', '12333', '2023-06-20 23:16:51', 2, 0, NULL, NULL);
INSERT INTO `apply_occupational_title` VALUES (6, '行业', '单位', '职称', '职务', '2', '一级', '4', '7', '123', '说明下为什么要申请', '2023-06-20 23:23:10', 2, 0, NULL, NULL);

查询语句

select * from apply_occupational_title
where applyTime in(
	select max(applyTime) from apply_occupational_title group by date(applyTime)
)order by applyTime desc;

date(字段)的使用：

当日期中有年月日时分秒时，使用这个之后只获取年月日