Re: Celko: help with an experiment

From: David Cressey <david_at_dcressey.com>
Date: Sun, 14 Jul 2002 13:49:07 GMT
Message-ID: <njfY8.19$Jd4.2110_at_petpeeve.ziplink.net>

> That one is easy. If the table is not empty (NULLs will not matter),
> you get the same answer. If the table is empty, then SUM(1) returns
> NULL and COUNT(*) returns 0.
>
> It is another verison of this "set as a completed whole" versus "set
> as a collection of things" problem.

Still, it might be worth asking your experimenters to try it, and see if any existing products give unexpected results. Received on Sun Jul 14 2002 - 15:49:07 CEST

This message: [ Message body ]
Next message: David Cressey: "Re: Help needed: Retrieve only rows where numbers are concurrent"
Previous message: Rauf Sarwar: "Re: HOW TO USE TELNET TO CONNECT TO MYSQL"
Maybe in reply to: --CELKO--: "Celko: help with an experiment"
In reply to --CELKO--: "Re: Celko: help with an experiment"
Next in thread: David Cressey: "Re: Help needed: Retrieve only rows where numbers are concurrent"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message