In the last episode (Sep 12), compo guy said:
> 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 loa
http://www.mysql.com/documentation/mysql/full/manual_toc.html#Working_with_NULL
On 12 Sep 2002, compo guy wrote:
> 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
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 exp
