我试图做的是选择和统计特定月份和年份的患者的诊断结果。我已经选择并统计了诊断,我的问题是如何在特定的月份和年份选择它。
我的查询SELECT diagnosis, count(diagnosis) as total from patient_records where deleted_at is null group by diagnosis
表结构patient_records
# Name Type Collation Attributes Null
1 idPrimary int(10) UNSIGNED No
2 diagnosis varchar(191) utf8_unicode_ci
3 remarks text utf8_unicode_ci Yes NULL
4 created_at timestamp Yes NULL
5 updated_at timestamp Yes NULL
6 deleted_at timestamp Yes NULL
7 patient_id int(10) UNSIGNED Yes NULL 请帮助我,我是一个初学者,在我脑海中的问题是这样的
SELECT diagnosis, count(diagnosis) as total from patient_records where
deleted_at is null and updated_at = month(5)&year(2019) group by
diagnosis发布于 2019-05-20 00:43:07
SELECT
diagnosis,
count(diagnosis) as total,
DATE_FORMAT(created_at, '%m') As month,
YEAR(created_at) as Year
from patient_records
where deleted_at is null
group by diagnosishttps://stackoverflow.com/questions/56208797
复制相似问题