SQL 练习4

  • 查询不存在" 01 "课程但存在" 02 "课程的情况
SELECT * from sc WHERE cid = '02' AND sid not in (SELECT sid from sc WHERE cid = '01')

image

posted @ 2021-08-18 16:44  弩哥++  阅读(37)  评论(0)  编辑  收藏  举报