ASELECT 学号,课程号,成绩 FROM选课成绩 WHERE 课程号 NOT IN("101","103")
BSELECT 学号,课程号,成绩 FROM选课成绩 WHERE 课程号<>"101" AND 课程号<>"103"
CSELECT 学号,课程号,成绩 FROM 选课成绩 WHERE NOT课程号="101" AND 课程号="103"
DSELECT 学号,课程号,成绩 FROM 选课成绩 WHERE NOT(课程号="101" OR 课程号="103")
Copyright © 2020 www.daanwo.com All Rights Reserved |