List:General Discussion« Previous MessageNext Message »
From:compo  guy Date:September 12 2002 4:30pm
Subject:Vaibhav Difference between amount <> null and amount is not null
View as plain text  
  What is the difference between the following sql queries written 
to
>extract tuples with the field amount having non null value:
>      select loan_number from loan where amount <> null (It 
>returns
>an empty set)
>      select loan_number from loan where amount is not null(It
>returns the expected result).
>

Thread
Vaibhav Difference between amount <> null and amount is not nullcompo  guy12 Sep
  • Re: Vaibhav Difference between amount <> null and amount is not nullVlatko Surlan12 Sep
  • Re: Vaibhav Difference between amount <> null and amount is not nullDan Nelson12 Sep