sql 查出相同的记录 并把相同记录 显示在一起
select c.workunit unitname,a.positionid,a.positiontype,a.isfirst,a.mastersort,a.directoraudit, c.writername,d.bookname,e.orgname unitid,b.positiontype applypositiontype, b.auditstate,b.editauditstate,b.appposiid,c.writerid,d.bookid,b.materid,b.isreceivedpaper, case when a.positiontype='' or a.positiontype is null then 1 else 0 end sort from teach_positionset a right join teach_applyposition b on b.appposiid = a.appposiid left join writer_declaration c on c.writerid=b.writerid left join teach_bookinfo d on d.bookid=b.bookid left join ba_organize e on e.orgid=c.unitid where 1=1 and b.auditstate=11 and b.isreceivedpaper=1 and d.bookid="1815f93a80da4427853a1a2a9faf06e2"
AND b.positiontype in(SELECT b.positiontype applypositiontype FROM teach_applyposition b group by b.positiontype having count(b.positiontype)>1) GROUP BY appposiid ORDER BY sort,a.positiontype,a.mastersort,b.positiontype
SELECT b.positiontype applypositiontype FROM teach_applyposition b group by b.positiontype having count(b.positiontype)>1的结果是
最新文章
- python统计某一个进程名所占用的内存
- linux 进程的创建
- Atitit. 类与对象的存储实现
- 小心buffer的拼接问题 --转
- java动手动脑课后思考题
- Java Evaluate Reverse Polish Notation(逆波兰式)
- [APUE]进程控制(中)
- 【BZOJ3531】旅行(树链剖分,线段树)
- UVA1627-Team them up!(动态规划)
- spring boot+kafka整合
- 【数据结构】约瑟夫问题 C语言链表实现
- 同步或者重构Activiti Identify用户数据的多种方案比较
- 详细解说Tomcat 设置虚拟路径的几种方法及为什么设置虚拟路径
- BZOJ4078 WF2014Metal Processing Plant(二分答案+2-SAT)
- Android中的各种访问权限Permission含义
- com.jcraft.jsch.JSchException: java.io.FileNotFoundException: file:\D:\development\ideaProjects\salary-card\target\salary-card-0.0.1-SNAPSHOT.jar!\BOOT-INF\classes!\keystore\login_id_rsa 资源未找到
- Nim游戏学习笔记
- int占几个字节?
- 在tomcat5中发布项目时,用IP地址+端口不能访问项目,而用localhost加端口时可以访问成功
- 作业派NABCD的特点分析
热门文章
- Matlab匿名函数,子函数,私有函数,重载函数,eval和feval函数
- 软件自带依赖库还是共享对象库/为什么linux发行版之间不能有一个统一的二进制软件包标准
- Flutter——Checkbox组件、CheckboxListTile(多选框组件)
- 二进制部署kubernetes集群(上篇)
- Mybatis.NET Oracle 线上神奇问题:Value does not fall within the expected range.
- tinymce + vue 富文本编辑
- ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded
- Linux服务器集群代理配置
- Arduino Tian开发板:一个功能强大的天气预报中心
- Android中sp和px之间关系探究