• 
  应出勤人数/实出勤数量=出勤率，要怎么写数据库

  ——应出勤人数SELECT d.depart_name,count(a.emp_id) as 个数FROM  employee aleft join (select  case ctype when '0' then '固定期限' when '1' then '无固定期限' else '其他' end as 合同类别,* from contact) b on a.emp_id=b.emp_id and b.status=1 left join Degrees c on a.edu_id=c.degree_id left join Departs d  on left(a.depart_id,7)=d.depart_idwhere work_status=1 AND LEFT(a.depart_id,7)='0080101' AND a.depart_id<>'0080101'group by d.depart_name——实出勤人数SELECT c.depart_name,count(DISTINCT a.emp_id) as 个数FROM dbo.TimeRecords aINNER JOIN dbo.employeeinfo b ON a.emp_id=b.emp_idINNER JOIN dbo.Departs c ON LEFT(b.depart_id, 9)=c.depart_idWHERE CONVERT(VARCHAR(10), a.sign_time, 120)=CONVERT(VARCHAR(10), GETDATE(), 120)AND LEFT(b.depart_id,7)='0080101' AND b.depart_id<>'0080101'GROUP BY c.depart_name

  261个浏览 2个回答 FineReport 2022年05月10日发布
• 
  按部门汇总出勤人数，写语句

  SELECT DISTINCT a.emp_id, b.emp_fname, CONVERT(VARCHAR(10), a.sign_time, 120) AS sign_date, c.depart_nameFROM dbo.TimeRecords a     INNER JOIN dbo.employeeinfo b ON a.emp_id=b.emp_id     INNER JOIN dbo.Departs c ON LEFT(b.depart_id, 9)=c.depart_idWHERE CONVERT(VARCHAR(10), a.sign_time, 120)=CONVERT(VARCHAR(10), GETDATE(), 120)AND LEFT(b.depart_id, 9) IN ('008010101', '008010102', '008010103');

  325个浏览 4个回答 FineReport 2022年05月10日发布
• 
  按课汇总在岗人数

  SELECT DISTINCT a.emp_id, b.emp_fname, CONVERT(VARCHAR(10), a.sign_time, 120) AS sign_date, c.depart_nameFROM dbo.TimeRecords a     INNER JOIN dbo.employeeinfo b ON a.emp_id=b.emp_id     INNER JOIN dbo.Departs c ON LEFT(b.depart_id, 9)=c.depart_idWHERE CONVERT(VARCHAR(10), a.sign_time, 120)=CONVERT(VARCHAR(10), GETDATE(), 120)AND LEFT(b.depart_id, 9) IN ('008010101', '008010102', '008010103');

  218个浏览 1个回答 FineReport 2022年05月07日发布
• 
  按部门在岗人数求和

  按部门汇总在岗人数求和

  297个浏览 2个回答 SQL 2022年05月06日发布

4

0

4

10