oracle查询多条条件各不相同的数据

最新推荐文章于 2023-01-16 22:23:45 发布

不到两点睡不着

最新推荐文章于 2023-01-16 22:23:45 发布

阅读量1k

点赞数 1

本文链接：https://blog.csdn.net/x546757078/article/details/50601759

版权

Object object = employeeService.queryBySqlUniqueResult("select"
+"(select count(*) from pm_overtime where empid="+employee.getId()+" and overtype=3 "
+" and overdate>= to_date('"+nf+"-01-01','YYYY-MM-dd')"
+" and overdate<=to_date('"+nf+"-03-31','YYYY-MM-dd'))加班一季度,"
+" (select count(*) from pm_overtime where empid="+employee.getId()+" and overtype=3 "
+ "and overdate>= to_date('"+nf+"-04-01','YYYY-MM-dd') "
+ "and overdate<=to_date('"+nf+"-06-30','YYYY-MM-dd')) 加班二季度,"
+"(select count(*) from pm_overtime where empid="+employee.getId()+" and overtype=3 "
+" and overdate>= to_date('"+nf+"-07-01','YYYY-MM-dd') "
+" and overdate<=to_date('"+nf+"-09-30','YYYY-MM-dd')) 加班三季度,"
+" (select count(*) from pm_overtime where empid="+employee.getId()+" and overtype=3 "
+" and overdate>= to_date('"+nf+"-10-01','YYYY-MM-dd') "
+" and overdate<=to_date('"+nf+"-12-30','YYYY-MM-dd')) 加班四季度,"
+"(select count(*) from PM_OFFWORK where empid="+employee.getId()+" and offTag=3 "
+" and offtxdate>= to_date('"+nf+"-01-01','YYYY-MM-dd') "
+" and offtxdate<=to_date('"+nf+"-03-31','YYYY-MM-dd')) 调休第一季度,"
+" (select count(*) from PM_OFFWORK where empid="+employee.getId()+" and offTag=3 "
+" and offtxdate>= to_date('"+nf+"-04-01','YYYY-MM-dd') "
+" and offtxdate<=to_date('"+nf+"-06-30','YYYY-MM-dd')) 调休第二季度,"
+" (select count(*) from PM_OFFWORK where empid="+employee.getId()+" and offTag=3 "
+" and offtxdate>= to_date('"+nf+"-07-01','YYYY-MM-dd') "
+" and offtxdate<=to_date('"+nf+"-09-30','YYYY-MM-dd')) 调休第三季度,"
+" (select count(*) from PM_OFFWORK where empid="+employee.getId()+" and offTag=3 "
+" and offtxdate>= to_date('"+nf+"-10-01','YYYY-MM-dd') "
+" and offtxdate<=to_date('"+nf+"-12-31','YYYY-MM-dd')) 调休第四季度,"
+" (select count(*) from pm_overtime where empid="+employee.getId()+" and overtype=3 "
+" and to_char(overdate,'YYYY')='"+nf+"') 加班总数,"
+" (select count(*) from PM_OFFWORK where empid="+employee.getId()+" and offTag=3 "
+" and to_char(offtxdate,'YYYY')='"+nf+"') 总数调休"
+" from dual");