病人表数据
检查表数据
1.统计年龄
1.1统计病人表中一段时间范围内的年龄病人数量(仅查询数据)
select f_Age, count(*) from workstationdb.t_patient INNER JOIN t_exam ON t_patient.f_PatientGuid = t_exam.f_PatientGuid where t_exam.f_RegisterTime between '2021-08-07 00:00:00' and '2021-09-18 23:59:59' and t_patient.f_Age BETWEEN 0 AND 10
结果
1.2.统计病人表中一段时间范围内的年龄病人 (查询不同年龄的数据)
select f_Age, count(*) from workstationdb.t_patient INNER JOIN t_exam ON t_patient.f_PatientGuid = t_exam.f_PatientGuid where t_exam.f_RegisterTime between '2021-08-07 00:00:00' and '2021-09-18 23:59:59' and t_patient.f_Age BETWEEN 0 AND 10 Group by f_Age
结果
2.统计检查表中诊断医生工作量
select f_MainDoctor, count(*) from workstationdb.t_exam where t_exam.f_RegisterTime between '2021-08-07 00:00:00' and '2021-09-18 23:59:59' Group by f_MainDoctor
结果
3. 统计病人表中的性别
select f_Gender, count(*) from workstationdb.t_patient INNER JOIN t_exam ON t_patient.f_PatientGuid = t_exam.f_PatientGuid where t_exam.f_RegisterTime between '2021-08-07 00:00:00' and '2021-09-18 23:59:59' Group by f_Gender
结果
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)