逻辑运算符
- and && a and b a&&b 2个为真才是真
- or || a or b a||b 一个是真就是真
- not ! not a !a 真为假,假为真
SELECT SID FROM STUDENT WHERE sid>2 AND Sage<=22
SELECT * FROM STUDENT WHERE SID!=3 == SELECT * FROM STUDENT WHERE NOT SID=3
SELECT SID FROM STUDENT WHERE sid>2 AND Sage<=22
SELECT * FROM STUDENT WHERE SID!=3 == SELECT * FROM STUDENT WHERE NOT SID=3