Hi there,
I'm currently have an sql statement that selects a week of descriptive
statistics for various historical weather variables, sorted by date.
SELECT to_char(date, 'MM')||to_char(date, 'DD') as date, max(tmax) as
max_tmax, min(tmax) as min_tmax, avg(tmax) as mean_tmax, stddev(tmax)
On Sep 23, 5:43 am, AnthonyV wrote:
> Hello,
>
> I have a table like :
>
> date | value
> ---
> 2009-09-19 | 1
> 2009-09-20 | 2
> 2009-09-21 | 6
> 2009-09-22 | 9
> 2009-09-23 | 1
>
> I'd like a request which gives me the sum of each
Hello,
I have a table like :
date|value
---
2009-09-19 | 1
2009-09-20 | 2
2009-09-21 | 6
2009-09-22 | 9
2009-09-23 | 1
I'd like a request which gives me the sum of each last n days.
For example, if I want the sum of each 3 days,
On Tuesday 22 September 2009 16:23:14 hfdabler wrote:
> Hello to all,
>
> Being in a pretty much international company, I have come here to ask a few
> things about ETL tools and their different languages.
>
> We have offices in the US, in Europe (Italy, France) and in China. We think
> English is
