On 03/06/2013 07:16 PM, François Beausoleil wrote:
Le 2013-03-06 à 21:42, Tony Dare a écrit :
I'm taking an standard deviation of a population and subtracting it from the
average of the same population and rounding the result. Sometimes that result
is negative and rounding it returns (or show
Le 2013-03-06 à 21:42, Tony Dare a écrit :
> I'm taking an standard deviation of a population and subtracting it from the
> average of the same population and rounding the result. Sometimes that result
> is negative and rounding it returns (or shows up as) a negative zero (-0) in
> a SELECT.
>
I'm taking an standard deviation of a population and subtracting it from
the average of the same population and rounding the result. Sometimes
that result is negative and rounding it returns (or shows up as) a
negative zero (-0) in a SELECT.
basically:
SELECT
client_name, avg(rpt_cnt),
std
