sql - 从查询中排除NULL时收到错误

我有这样的查询：

SELECT distinct [F_Exhibitor_Name],
       F_Site
  FROM [V_ExhibitorLocation]
 WHERE F_ExhibitionCode ='10996' is not null
 ORDER BY F_Exhibitor_Name

但它显示错误


关键字“ is”附近的语法不正确


。

最佳答案

以下布尔条件完全无效，无论您以何种方式解析它：

 WHERE F_ExhibitionCode ='10996' is not null

大概，您只想要：

 WHERE F_ExhibitionCode = '10996'

这等效于：

 WHERE F_ExhibitionCode = '10996' AND F_ExhibitionCode IS NOT NULL

关于sql - 从查询中排除NULL时收到错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/30217861/