Null value in column resulting into no output in sql query

Question

I have 2 tables (stud and stud1). Both having 2 columns but stud1 contains 1 record which is null.

data from query

I have created following 2 queries.First one is returning the accurate result but other one which is using not in returning nothing. I guess that is because of the null value. But I don't understand the reason for it. Can someone help me with this?

enter image description here

Were you expecting *3 India* to appear for your second query? — Sun, Sep 15 '14 at 05:03
See http://stackoverflow.com/questions/129077/not-in-clause-and-null-values — paxdiablo, Sep 15 '14 at 05:09

score 0 · Accepted Answer · edited May 23 '17 at 10:26

0

See NOT IN clause and NULL values.

That's because your 2nd query equals:

SELECT * FROM #stud
WHERE ID <> NULL

When ansi_nulls is on, ID <> NULL is unknown, so you won't get any rows.

edited May 23 '17 at 10:26

Community

1
1

answered Sep 15 '14 at 05:13

zhongxiao37

917
7
16

Null value in column resulting into no output in sql query

1 Answers1