问题
填空题
[问题3] 用SQL语言写出查询:查询年龄不在20~23岁(包括20岁和23岁)之间的学生的姓名,系别和年龄。
答案
参考答案:SELECT Shame, Sdept, Sage FROM Student
解析:
WHERE Sage NOT BETWEEN 20 AND 23或SELECT Shame, Sdept, Sage FROM Student WHERE NOT (Sage BETWEEN 20 AND 23 )或SELECT Sname, Sdept, Sage FROM Student WHERE (Sage <20) AND (Sage >23)