SQL逻辑运算符

Question

什么职业不是学生、律师或教育工作者？按字母顺序降序列出它们。

SELECT Occupation 
  FROM Viewer 
 WHERE occupation NOT IN 'student,lawyer,educator' 
ORDER BY occupation desc; 

我一直在出现错误，我做错了什么？

- ckp25

Answer 1

IN需要用括号包围起来的表达式列表：

SELECT Occupation
FROM Viewer
WHERE occupation NOT IN ('student','lawyer','educator')
ORDER BY occupation desc;

请参阅有关IN的文档查看正确的语法：

- Mark Byers