三种方法匹配日期
21年8月份练题总数
http://www.nowcoder.com/practice/b8f30b239b454ed490367b53ea95607d
- like
- year(date)='2021' month(date)='08'
- date_format(date,'%Y-%m')='2021-08'
# select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail
# where date like '%2021-08%';
##第二种办法
# select count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail
# where YEAR(date)='2021' and MONTH(date)='08';
##第三种办法
SELECT count(distinct device_id) as did_cnt,count(question_id) as question_cnt from question_practice_detail
where DATE_FORMAT(date,'%Y-%m')='2021-08';
