Simple sql question, I think.
- From: DaLoverhino <DaLoveRhino@xxxxxxxxxxx>
- Date: Sat, 28 Jul 2007 17:20:39 -0000
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.
.
- Follow-Ups:
- Re: Simple sql question, I think.
- From: William Robertson
- Re: Simple sql question, I think.
- From: Michel Cadot
- Re: Simple sql question, I think.
- From: DA Morgan
- Re: Simple sql question, I think.
- Prev by Date: Re: v$sql - when information is updated
- Next by Date: Re: Simple sql question, I think.
- Previous by thread: buffer cache and Rollback
- Next by thread: Re: Simple sql question, I think.
- Index(es):