Re: All hail Bob (not)!

From: <jiiiiim_at_hotmail.com>
Date: 7 May 2006 20:42:00 -0700
Message-ID: <1147059720.251520.287120_at_e56g2000cwe.googlegroups.com>

Frank Hamersley wrote:
> Bob Badour wrote:

[..]

>> I agree it is no problem to write the query to get the average ages
>> where the age is known. Using null, how does one write the query to
>> get the correct result, ie. the average is unknown ?



> select case when count(*) = count(age)

>             then avg(age)

>             else null

>        end as avgage

> from table

What say you Bob? The silence to date has been most instructive.

Cheers, Frank. Received on Mon May 08 2006 - 05:42:00 CEST

This message: [ Message body ]
Next message: Bob Badour: "Re: All hail Bob (not)!"
Previous message: Frank Hamersley: "Re: Anybody for changing light bulbs?"
In reply to Jon Heggland: "Re: Lucid statement of the MV vs RM position?"
Next in thread: Bob Badour: "Re: All hail Bob (not)!"
Reply: Bob Badour: "Re: All hail Bob (not)!"

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

Original text of this message