| List: | General Discussion | « Previous MessageNext Message » | |
| From: | C.R.Vegelin | Date: | December 6 2006 9:57am |
| Subject: | SUM() of 1 and NULL is 1 ? | ||
| View as plain text | |||
Hi List, I need to SUM() on months from a table like: CREATE TABLE `data` ( `Jan` float default NULL, ... ) ENGINE=MyISAM; # V 5.0.15 Months may have NULL values, like: INSERT INTO data (Jan) VALUES (1), (NULL); However, when I use SELECT SUM(Jan) AS Jan, the returned value is 1 in stead of NULL. How to get a result NULL when in such a case ? TIA, Cor
| Thread | ||
|---|---|---|
| • SUM() of 1 and NULL is 1 ? | C.R.Vegelin | 6 Dec |
| • RE: SUM() of 1 and NULL is 1 ? | Peter Lauri | 6 Dec |
| • Re: SUM() of 1 and NULL is 1 ? | ViSolve DB Team | 6 Dec |
| • Re: SUM() of 1 and NULL is 1 ? | ViSolve DB Team | 6 Dec |
| • Re: SUM() of 1 and NULL is 1 ? | Remo Tex | 7 Dec |
| • Re: SUM() of 1 and NULL is 1 ? | C.R.Vegelin | 6 Dec |
| • Re: SUM() of 1 and NULL is 1 ? | Martijn Tonies | 6 Dec |
| • Re: SUM() of 1 and NULL is 1 ? | Peter Brawley | 6 Dec |
