union的使用
来源:互联网 发布:js修改input的value 编辑:程序博客网 时间:2024/05/22 14:19
需求:把员工全部显示在积分排名里面;select m.id, m.empId, m.orgId, m.eveName, m.czSocre, m.czType, m.optDate, m.optType, m.operPerson, m.checkPerson, m.jktypeid, m.jktypename, m.isprint, m.creatTime,m.remark,m.tatalA, (select employeeName from QY_EMPLOYEE where employeeId = m.empId) employeename, (select jobNumber from QY_EMPLOYEE where employeeId = m.empId) jobnumber, (select departmentName from QY_ORGANIZATION where ID = (select department from QY_EMPLOYEE where employeeId = m.empId)) departmentname, (select sum(czSocre)czjf from CZ_QUERY_RANK where orgId = 'E000102' AND isprint='1' and empId = m.empId) czSocrejf, (select sum(czSocre)czkf from CZ_QUERY_RANK where orgId = 'E000102' AND isprint='2' and empId = m.empId) czSocrekf from ( select g.*,tt.tatalA from CZ_QUERY_RANK g inner join ( SELECT x.empId,x.orgId,(x.jfa-IFNULL(b.kfa,0)) tatalA FROM (SELECT empId,orgId,SUM(optA) jfa FROM JF_QUERY_RANK WHERE orgId='E000102' AND scoType='1' GROUP BY empId ) x LEFT JOIN( SELECT empId,orgId,SUM(optA) kfa FROM JF_QUERY_RANK WHERE orgId='E000102' AND scoType='2' GROUP BY empId ) b ON x.empId=b.empId )tt on g.empId = tt.empId group by empId ) m where m.orgId = 'E000102'unionselect NULL AS id, employeeId as empId,enterpriseId as orgId,null AS eveName,0 AS czSocre,null AS czType,null AS optDate, null AS optType,null AS operPerson,null AS checkPerson,null AS jktypeid,null AS jktypename,null AS isprint,null AS creatTime,null AS remark,0 AS tatalA,employeeName as employeename,jobNumber as jobnumber,(select departmentName from QY_ORGANIZATION where ID = department) departmentname,0 AS czSocrejf,0 AS czSocrekf from QY_EMPLOYEE where enterpriseId='E000102'
0 0
- union的使用
- union 语句的使用
- union的谨慎使用
- union的使用
- union 的使用
- c++ union的使用
- 经典union的使用
- UNION的使用
- union的使用原则
- Union的使用
- 联合体union的使用
- union的使用
- union的使用注意事项
- SQL的UNION使用
- UNION ALL的使用
- union和union all的使用
- union _ULARGE_INTEGER 的使用问题!
- oracle中union的使用
- 后缀表达式(逆波兰表达式),并求值(可求浮点、负数与大于10的数),C++实现
- 【css基础】div父元素根据子元素高度自适应高度
- 欢迎使用CSDN-markdown编辑器
- 是什么造就了如此庞大的PHP帝国?
- AppInventor专题:如何实现两个页面之间的跳转
- union的使用
- 50. Pow(x, n) 【M】【62】
- 227. Basic Calculator II
- 计蒜客 11065 Candy
- 利用AppInventor读取天气预报接口(完整版)
- 菜鸟第一次写博客
- Struts2:ClassNotFoundException: org...dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
- 棋子染色问题(burnside引理或者polya定理)
- Git小记