Complex SQL
From: Jim <jschneider_at_kjinteractive.com>
Date: 25 Oct 2002 09:37:05 -0700
Message-ID: <8e6a91e3.0210250837.57983b3b_at_posting.google.com>
Date: 25 Oct 2002 09:37:05 -0700
Message-ID: <8e6a91e3.0210250837.57983b3b_at_posting.google.com>
Maybe not so complex, but I don't know how to do it.
My table is setup like this:
Date Numeric Value
What I'd like to do is to get the average (AVG) of
the "Numeric Value" column at each date interval, with a
single SQL statement. That is, an SQL statement that
returns:
-------------- --------------
01/02/2002 10
01/03/2002 17
01/04/2002 83
....
01/02/2002 10
01/03/2002 13.5 [(10 + 17)/2]
01/04/2002 55 [(10 + 17 + 83)/3]
Thanks in advance for any help. Received on Fri Oct 25 2002 - 18:37:05 CEST