| 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 null | compo guy | 12 Sep |
| • Re: Vaibhav Difference between amount <> null and amount is not null | Vlatko Surlan | 12 Sep |
| • Re: Vaibhav Difference between amount <> null and amount is not null | Dan Nelson | 12 Sep |
