On Wed, 27 Jan 2010, Віталій Тимчишин wrote:
> How about SELECT SUM (case when id > 1200000 and id < 1210000 then 1 end)
> from tbl_tracker;
That is very interesting.
> * All the functions should be noop for null input
Alas, not true for COUNT(*), AVG(), etc.
Matthew
--
An optimist sees the glass as half full, a pessimist as half empty,
and an engineer as having redundant storage capacity.