摘要:
select b.OrganID,count(a.OrganID) from View_HREmployees a,SYSOrgans b where a.OrganID=b.OrganID group by b.OrganIDa为员工表,b 为机构表--统计合同有多少人签 select h.IPID,COUNT(s.EMPSYSID) from HRContract h,SYSEmployees s where h.EMPSYSID=s.EMPSYSID group by h.IPIDIPID是合同编号h合同表,s 员工表---考勤汇总 按人按年按月select NEWID() R... 阅读全文