Simple sql question, I think.

Giganews Newsgroups
Subject: Simple sql question, I think.
Posted by:  DaLoverhino (DaLoveRhi…@hotmail.com)
Date: Sat, 28 Jul 2007

Is there a way to take the average of a group of averages in a sql
statement?

So for instance:

select a, b, avg( c) from T group by a, b;

-- That finds the average of each group a,b.

Now how to take the average of those averages?  I can create a view I
suppose, but I'm curious to know if there was a way to do it without
resorting to making a view?

thanks.

Replies