note/work/教育E卡通/查询成绩sql.md
2025-11-19 10:16:05 +08:00

13 lines
357 B
Markdown

`school_id` = '1500000100302563181';
`class_id` = '1500000100355159224';
`user_id` = '1500000100355186319';
---
SELECT exam_name, user_name, subject_name, score, standard_score, class_rank, school_rank,exam_time
FROM `dw_report_user_subject_fact_withmask_month_202510`
WHERE `class_id` = '1500000100355159224' AND `user_id` = '1500000100355186319'
---