案例2:用一条SQL查询出数学语文成绩都大于80分的学生姓名?
案例2:⽤⼀条SQL查询出数学语⽂成绩都⼤于80分的学⽣姓输入姓名查询成绩在线名?⽅法1:查出科⽬成绩有⼩于80分的学⽣姓名,再约束并去重学⽣不等于查出来的姓名select distinct A.name from t_score A where A.name not in(select distinct B.name from t_score B where B.fenshu <=80)⽅...
2024-05-20 43 0