SQL统计查询

病人表数据

检查表数据

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

结果