题解 | #计算刷题总人数#
计算刷题总人数
https://www.nowcoder.com/practice/aec305f85d75482e83dc69dd48e2cbfa
SELECT COUNT(DISTINCT user_id) AS 'cnt' FROM questions_pass_record_detail;
要点:计算时要排除掉重复的id
计算刷题总人数
https://www.nowcoder.com/practice/aec305f85d75482e83dc69dd48e2cbfa
SELECT COUNT(DISTINCT user_id) AS 'cnt' FROM questions_pass_record_detail;
要点:计算时要排除掉重复的id
相关推荐