使用！= condition运行查询时出现问题 [英] PROBLEM while running a query with != condition

问题描述

sql查询，带有！=条件无法工作

我的查询是

sql query with != condition not working
my query is

Select regno from member_master where parentregnoM=2 and parentPosM=1 and registerAS  != 'Free'

没有给我任何结果

但是当我写出像

not giving me any result
but when i write the query like

Select regno from member_master where parentregnoM=2 and parentPosM=1

显示正确的结果

其中registerAS字段值为null所以第一个查询也显示结果

show me right result
where in registerAS field values are null so first query also shows the results

推荐答案

如果列RegisterAs为null，您可以尝试e以下

If the column RegisterAs is null, you could try the following

SELECT regno 
FROM   member_master 
WHERE  parentregnoM = 2 
AND    parentPosM   = 1 
AND    (   registerAS  != 'Free'
       OR  registerAS  IS NULL)

您好，



尝试下面的一个

Hi ,

try the below one

SELECT regno
FROM   member_master WHERE  parentregnoM = 2 AND    parentPosM   = 1
AND    (   registerAS  != 'Free'
       OR  registerAS  IS NULL)

而不是 ！=

使用... <>

快乐编码！

：）

instead of !=
use... <>
Happy Coding!
:)

这篇关于使用！= condition运行查询时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！