create table `t_archives` (
`id` varchar (96),
`department_id` varchar (96)
);
insert into `t_archives` (`id`, `department_id`) values('5b028f80a3105f31d46ce114','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b028fa500326e4f6a2f9646','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b028fc2a3105f31d46ce120','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b028ff6a3105f31d46ce12d','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b029012a3105f31d46ce13a','0000000028');
insert into `t_archives` (`id`, `department_id`) values('5b02903fa3105f31d46ce140','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b0290a1a3105f31d46ce149','0000000028');
insert into `t_archives` (`id`, `department_id`) values('5b0290a6a3105f31d46ce14f','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b0292b500326e4f6a2f975e','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b02947ea3105f31d46ce169','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b02950900326e4f6a2f97cc','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b0295ca00326e4f6a2f9811','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b0295dea3105f31d46ce17c','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b02962c00326e4f6a2f9829','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b0296aa00326e4f6a2f9847','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b0296f4a3105f31d46ce188','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b02976800326e4f6a2f988d','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b0297c9a3105f31d46ce194','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b0297e000326e4f6a2f98bf','0000000028');
insert into `t_archives` (`id`, `department_id`) values('5b029915a3105f31d46ce19a','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b02997d00326e4f6a2f9951','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b029da900326e4f6a2f9a52','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b029e1600326e4f6a2f9a6a','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b036bcea3105f31d46ce230','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b036ca6a3105f31d46ce23c','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b036ceca3105f31d46ce247','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b036cf900326e4f6a2fa511','0000000027');
insert into `t_archives` (`id`, `department_id`) values('5b036d1aa3105f31d46ce24d','0000000028');
insert into `t_archives` (`id`, `department_id`) values('5b036d2ca3105f31d46ce255','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b036d4000326e4f6a2fa526','0000000028');
insert into `t_archives` (`id`, `department_id`) values('5b036d9c00326e4f6a2fa530','1000002184');
insert into `t_archives` (`id`, `department_id`) values('5b036deca3105f31d46ce25c','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b036e41a3105f31d46ce262','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b036e62a3105f31d46ce268','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b036ed7a3105f31d46ce271','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b036eefa3105f31d46ce279','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b036f0800326e4f6a2fa554','0000000027');
insert into `t_archives` (`id`, `department_id`) values('5b036f3800326e4f6a2fa568','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5b036fbe00326e4f6a2fa57f','1000002184');
insert into `t_archives` (`id`, `department_id`) values('5b036fc7a3105f31d46ce282','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b037018a3105f31d46ce289','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b03702000326e4f6a2fa593','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b037ff700326e4f6a2fa7bf','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b062f83a310e8b66f0b77bb','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b062f8a00322dffdbac3151','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b062fcaa310e8b66f0b77c1','0000000033');
insert into `t_archives` (`id`, `department_id`) values('5b062fd100322dffdbac3175','0000000025');
insert into `t_archives` (`id`, `department_id`) values('5b062ff700322dffdbac3187','0000000026');
insert into `t_archives` (`id`, `department_id`) values('5b062ff900322dffdbac318e','0000000024');
insert into `t_archives` (`id`, `department_id`) values('5c662ffd84ae63c8781f7b04','0000000022');
如果建表语句报错,建议手写创建表的语句
SELECT
c.id "id",
c.department_id "departmentId" ,
d.count
FROM
t_archives c
LEFT JOIN
(
SELECT
COUNT(1) "count",
b.department_id "departmentId",
b.id
FROM
t_archives b
WHERE
b.id IN(
'5c662ffd84ae63c8781f7b04','5b062ff900322dffdbac318e','5b062ff700322dffdbac3187','5b062fd100322dffdbac3175','5b062fcaa310e8b66f0b77c1','5b062f8a00322dffdbac3151','5b062f83a310e8b66f0b77bb','5b037ff700326e4f6a2fa7bf','5b03702000326e4f6a2fa593','5b037018a3105f31d46ce289','5b036fc7a3105f31d46ce282','5b036fbe00326e4f6a2fa57f','5b036f3800326e4f6a2fa568','5b036f0800326e4f6a2fa554','5b036eefa3105f31d46ce279','5b036ed7a3105f31d46ce271','5b036e62a3105f31d46ce268','5b036e41a3105f31d46ce262','5b036deca3105f31d46ce25c','5b036d9c00326e4f6a2fa530','5b036d4000326e4f6a2fa526','5b036d2ca3105f31d46ce255','5b036d1aa3105f31d46ce24d','5b036cf900326e4f6a2fa511','5b036ceca3105f31d46ce247','5b036ca6a3105f31d46ce23c','5b036bcea3105f31d46ce230','5b029e1600326e4f6a2f9a6a','5b029da900326e4f6a2f9a52','5b02997d00326e4f6a2f9951','5b029915a3105f31d46ce19a','5b0297e000326e4f6a2f98bf','5b0297c9a3105f31d46ce194','5b02976800326e4f6a2f988d','5b0296f4a3105f31d46ce188','5b0296aa00326e4f6a2f9847','5b02962c00326e4f6a2f9829','5b0295dea3105f31d46ce17c','5b0295ca00326e4f6a2f9811','5b02950900326e4f6a2f97cc','5b02947ea3105f31d46ce169','5b0292b500326e4f6a2f975e','5b0290a6a3105f31d46ce14f','5b0290a1a3105f31d46ce149','5b02903fa3105f31d46ce140','5b029012a3105f31d46ce13a','5b028ff6a3105f31d46ce12d','5b028fc2a3105f31d46ce120','5b028fa500326e4f6a2f9646','5b028f80a3105f31d46ce114'
)
GROUP BY
b.department_id
) d
ON c.department_id=d.departmentId
WHERE
c.id IN (
'5c662ffd84ae63c8781f7b04','5b062ff900322dffdbac318e','5b062ff700322dffdbac3187','5b062fd100322dffdbac3175','5b062fcaa310e8b66f0b77c1','5b062f8a00322dffdbac3151','5b062f83a310e8b66f0b77bb','5b037ff700326e4f6a2fa7bf','5b03702000326e4f6a2fa593','5b037018a3105f31d46ce289','5b036fc7a3105f31d46ce282','5b036fbe00326e4f6a2fa57f','5b036f3800326e4f6a2fa568','5b036f0800326e4f6a2fa554','5b036eefa3105f31d46ce279','5b036ed7a3105f31d46ce271','5b036e62a3105f31d46ce268','5b036e41a3105f31d46ce262','5b036deca3105f31d46ce25c','5b036d9c00326e4f6a2fa530','5b036d4000326e4f6a2fa526','5b036d2ca3105f31d46ce255','5b036d1aa3105f31d46ce24d','5b036cf900326e4f6a2fa511','5b036ceca3105f31d46ce247','5b036ca6a3105f31d46ce23c','5b036bcea3105f31d46ce230','5b029e1600326e4f6a2f9a6a','5b029da900326e4f6a2f9a52','5b02997d00326e4f6a2f9951','5b029915a3105f31d46ce19a','5b0297e000326e4f6a2f98bf','5b0297c9a3105f31d46ce194','5b02976800326e4f6a2f988d','5b0296f4a3105f31d46ce188','5b0296aa00326e4f6a2f9847','5b02962c00326e4f6a2f9829','5b0295dea3105f31d46ce17c','5b0295ca00326e4f6a2f9811','5b02950900326e4f6a2f97cc','5b02947ea3105f31d46ce169','5b0292b500326e4f6a2f975e','5b0290a6a3105f31d46ce14f','5b0290a1a3105f31d46ce149','5b02903fa3105f31d46ce140','5b029012a3105f31d46ce13a','5b028ff6a3105f31d46ce12d','5b028fc2a3105f31d46ce120','5b028fa500326e4f6a2f9646','5b028f80a3105f31d46ce114'
)
ORDER BY
d.count DESC,d.departmentId DESC;
文章浏览阅读3k次。一、进行界面布局的时候,往往需要将界面显示在整个桌面的中心位置,所以需要进行一下处理二、加上头文件#include <QDesktopWidget>#include <QApplication>三、再在构造函数中加上代码 QDesktopWidget *deskdop=QApplication::desktop(); move((deskdop->width()-this->width())/2, (deskdop->height()-th_qt dialog 位于面板中间
文章浏览阅读233次。我结合老师课上所讲内容写这个栏目,为了督促自己学习,也希望把知识分享给更多人,因此写下这。大家批判性吸收,有需要对应ppt课件资源的请私信我。
文章浏览阅读1.8k次。Django v3.1的主要更新之一便是完善了对JSON数据存储的支持,新增models.JSONField和forms.JSONField,可在所有受支持的数据库后端上使用。_django jsonfield
文章浏览阅读607次。随着互联网各岗位精细化分工的普及,出现了很多的系统架构设计,比如常见的前后端分离架构,后端提供接口给前端,前端根据接口的数据进行渲染,大家各执其职,效率也非常的高,但是随着接口的增加,如果不统一的规范就会额外的增加大量的沟通成本以及学习成本,对管理者而言是非常的不利。为此,我在这篇文章分享给大家一个Java生鲜电商平台中如何返回统一格式的API的整体架构设计。一般系统的大致整体架构图如下:..._某个接口不需要统一返回处理
文章浏览阅读953次,点赞19次,收藏19次。磁盘分区就像是我们整理衣柜或者设计户型图,通过合理的划分和管理,可以让我们更高效地使用计算机,同时也可以保护我们的数据安全。所以,理解和掌握磁盘分区的知识,对于我们来说是非常重要的。_分区有哪些类型,设置活动分区的目的是什么
文章浏览阅读1w次,点赞3次,收藏8次。RNG主要特性 RNG 处理器是一个以连续模拟噪声为基础的随机数发生器,在主机读数时提供一个 32 位的 随机数。RNG的主要特性 ● 提供由模拟量发生器产生的 32 位随机数 ● 两个连续随机数的间隔为 40 个 PLL48CLK 时钟信号周期 ● 通过监视 RNG 熵来标识异常行为(产生稳定值,或产生稳定的值序列) ● 可被禁止以降低功耗RNG功能描述 随机数发生器采用模拟电路实_ll_rng_isactiveflag_drdy
文章浏览阅读1k次,点赞28次,收藏8次。ThinkPHP5.0验证使用独立的类或者验证器进行验证。_tp5自定义验证规则
文章浏览阅读1.8k次。下面是用TensorFlow实现Logistic Regression,步骤都做了标注,不详细说了。#encoding:utf-8import tensorflow as tf# 装在MNIST数据from tensorflow.examples.tutorials.mnist import input_datamnist = input_data.read_data_sets("..._eval('softmax')
文章浏览阅读4.5k次。原标题:不想开WPS会元,教你如何免费使用它会员功能关于PDF格式转换的问题,小仙女也给大家推送过不少软件和网站,有单独转换的,有即可以转换又可以编辑的,都非常好用。但是小仙女平时分享的无论是软件还是网站,基本都是电脑端产品,电脑编辑PDF文档确实方便,但是我们总不能时时刻刻把电脑带在身上。有时候出门在外,遇到需要处理的紧急文档该怎么办呢?这个时候你可能会想到用手机啊,手机上装个WPS就好了。WP..._计算机报考wps的话会不会有会员
文章浏览阅读1.4w次。一、打开已有工程遇到的问题1、如下几张图,提示很友好,但我都点击了确定,并进行了运行,提示:此项目需要 MFC 库。从 Visual Studio 安装程序(单个组件选项卡)为正在使用的任何。。。2、根据提示安装依赖库(1)搜索栏搜索应用Visual Studio Installer(2)双击打开,选择单个组件安装,选择MFC 库进行安装..._此项目需要 mfc 库。从 visual studio 安装程序(单个组件选项卡)为正在使用的任何
文章浏览阅读834次。题目:做题思路:做这题我们首先要了解什么是欧拉函数欧拉函数:就是对于一个正整数n,小于n且和n互质的正整数(包括1)的个数,记作φ(n) 。欧拉函数的通式:φ(n)=n*(1-1/p1)(1-1/p2)(1-1/p3)*(1-1/p4)……(1-1/pn)其中p1, p2……pn为n的所有质因数,n是不为0的整数。φ(1)=1(唯一和1互质的数就是1本身)。那么题目所给的H(x)表达式为H(x)=(1-1/p1)(1-1/p2)(1-1/p3)*(1-1/p4)……(
文章浏览阅读289次。今天做项目时踩到了vue-router传参的坑(query和params),所以决定总结一下二者的区别。直接总结干货!!!1.query方式传参和接收参数传参: this.$router.push({ path:'/xxx', query:{ id:id } ..._vue query传参与接收参数将参数绑定