Hi,
I am querying a column:
Column
1
2
3
4
null
null
query:
Select * from table
where column != 1
Now , it just ignores null values and returns 2 3 4.
I have to query like this to get the null values:
select * from table
where column != 1 or column is null
is there any other way i can query the column to return the null value as well. why it is ignoring the null in the first query ?
View Complete Post