Re: Celko: help with an experiment

From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 12 Jul 2002 12:40:25 -0700
Message-ID: <c0d87ec0.0207121140.c5e9787_at_posting.google.com>

>> see if the following functions both return the same value:

sum(1) and count(*)

For various kinds of selection criteria. <<

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. Received on Fri Jul 12 2002 - 21:40:25 CEST

This message: [ Message body ]
Next message: Jerason Banes: "Re: DB clasical structure violation"
Previous message: Kai Großjohann: "Re: Approximate structural conditions in trees"
Maybe in reply to: --CELKO--: "Celko: help with an experiment"
In reply to David Cressey: "Re: Celko: help with an experiment"
Next in thread: Jerason Banes: "Re: DB clasical structure violation"
Reply: David Cressey: "Re: Celko: help with an experiment"

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

Original text of this message