SEO

#1 (**permalink**) 02-27-2008, 06:53 AM

Hi

I have a table with the following attributes: Timestamp and a value.

I would like to calculate the percentage of how many values occuring
above a figurative threshold value between the hours of 6 and 10 AM?

Is there a function available for doing this in a sql statement?

Thanks
Mahesh

#2 (**permalink**) 02-27-2008, 06:53 AM

Mahesh S wrote:
> Hi
>
> I have a table with the following attributes: Timestamp and a value.
>
> I would like to calculate the percentage of how many values occuring
> above a figurative threshold value between the hours of 6 and 10 AM?
>
> Is there a function available for doing this in a sql statement?
SELECT (SUM(val) * 100)/COUNT(1) FROM T WHERE stamp BETWEEN ? AND ?

Not sure where the problem lies....

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#3 (**permalink**) 02-27-2008, 06:53 AM

well, i think i ahvent explained clearly..

consider this table

timestamp value
2005/07/08 6
2005/07/09 7
2005/07/10 8
2005/07/11 6

i would like to calculate the percentage of the a value occuring
between 5 and 7 between two dates?

does that make sense?

cheers

#4 (**permalink**) 02-27-2008, 06:53 AM

Mahesh S wrote:
> well, i think i ahvent explained clearly..
>
> consider this table
>
> timestamp value
> 2005/07/08 6
> 2005/07/09 7
> 2005/07/10 8
> 2005/07/11 6
>
> i would like to calculate the percentage of the a value occuring
> between 5 and 7 between two dates?
SELECT SUM(CASE WHEN value BETWEEN 5 AND 7 THEN 1.0 END)/ COUNT(1)
FROM T WHERE timestamp BETWEEN ? AND ?

That ought to do it.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

calculation percentages using sql command