liuyong2730
- 在2020年06月07日加入
- 点赞能量: 100%
- 点赞价值: 0
总结很棒
-
-
hujiahao
2020-06-22
-
👍
-
-
默念641
2020-06-13
-
这么写感觉更简洁:
selectstu_name,
ifnull(sum(lesson_name="语文")*score,0)语文,
ifnull(sum(lesson_name="数学")*score,0)数学,
ifnull(sum(lesson_name="英语")*score,0)英语,
ifnull(sum(lesson_name="物理")*score,0)物理,
ifnull(sum(lesson_name="化学")*score,0)化学,
sum(score)总分
fromt_stu_profilerightjoint_scoreleftjoint_lesson
ont_score.lesson_id=t_lesson.lesson_id
ont_score.stu_id=t_stu_profile.stu_id
whereclass_id='0611'andgender....
-
-
liting李
2020-06-13
-