章杭

zhanghang
2248 号测试 成员, 2020-02-25 02:58:49 加入
1.8k
个人主页浏览
  • 20200326 连接子查询作业

    2020-07-24 10:57

    老师讲的第四种答案
    select * from tb_lemon_score t1 where not exist (select * from tb_lemon_score t2 where t1.sname=t2.sname and t2.score <=80)
    可以改成 select * from tb_lemon_score t1 where t1.sname not exist (select * from tb_lemon_score t2 where t2.score <=80) 吗?课堂上发不出去。。