|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
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?