mysql group 最后一条,mysql实现group by后取各分组的最后一条

DROP TABLE IF EXISTS `tb_dept`;

CREATE TABLE `tb_dept`  (

`id` bigint(20) UNSIGNED NOT NULL,

`parent_id` bigint(20) NULL DEFAULT NULL,

`dept_code` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

`dept_name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE,

INDEX `idx_parent_id_code`(`parent_id`, `dept_code`) USING BTREE,

INDEX `idx_code_parent_id`(`dept_code`, `parent_id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic;

INSERT INTO `tb_dept` VALUES (1, NULL, '01', '葫芦科技');

INSERT INTO `tb_dept` VALUES (2, 1, '001', '运营部');

INSERT INTO `tb_dept` VALUES (3, 1, '002', '技术部');

INSERT INTO `tb_dept` VALUES (4, 1, '003', '产品部');

INSERT INTO `tb_dept` VALUES (5, 1, '004', '设计部');

INSERT INTO `tb_dept` VALUES (6, 2, '00101', '运营一部');

INSERT INTO `tb_dept` VALUES (7, 2, '00102', '运营二部');

INSERT INTO `tb_dept` VALUES (8, 3, '00201', '技术一部');

INSERT INTO `tb_dept` VALUES (9, 3, '00202', '技术二部');

INSERT INTO `tb_dept` VALUES (10, 3, '00203', '技术三部');

INSERT INTO `tb_dept` VALUES (11, 3, '00204', '技术四部');

INSERT INTO `tb_dept` VALUES (12, 4, '00301', '运营一部');

INSERT INTO `tb_dept` VALUES (13, 4, '00302', '运营二部');

INSERT INTO `tb_dept` VALUES (14, 4, '00303', '运营三部');

INSERT INTO `tb_dept` VALUES (15, 5, '00401', '设计一部');

INSERT INTO `tb_dept` VALUES (16, 8, '0020101', '技术一部一组');

INSERT INTO `tb_dept` VALUES (17, 8, '0020102', '技术一部二组');

INSERT INTO `tb_dept` VALUES (18, 9, '0020201', '技术二部一组1111');

INSERT INTO `tb_dept` VALUES (19, 10, '0020301', '技术三部一组');