006 10:18 AM
> To: mysql@lists.mysql.com
> Subject: Invalid syntax with STD() function when more than one field is
> used in select query
>
> Hello,
>
> I am encountering a strange issue when using the STD function. On my
> local development machine (MYSQL version 4.18-nt
Hello,
I am encountering a strange issue when using the STD function. On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:
SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY
When I test this query on
Hi,
(B
(BI have a table with the sales of each product by month (in the format
(Bmm).
(BFor example: (table name: ventas)
(B
(Bsale_date prod_idsales
(B200301 A20
(B200302 A16
(B200303 A18
(B200301 B12
(
[EMAIL PROTECTED] wrote:
> Is this correct?...how MySQL calculate this?...
Yes.
Std. Dev = Math.sqrt(sum((val[i]-avg)**2) / count(i));
Verified with a trivial program.
>
> mysql> select * from temp;
> +
.84 |
| 00029.28 |
+--+
8 rows in set (0.00 sec)
mysql>
mysql> select std(cal) from temp;
+------+
| std(cal) |
+--+
| 0.205240 |
+--+
1 row in set (0.06 sec)
mysql>
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel.No. (088) 858
Hi
I'm doing a simple query using the function STD but I'm getting zeros as
answer. I know that zero is a perfectly good answer for standart
deviation but in this case I should get some positive values :-)
Is there something wrong with this function ?
My sql string is the folowi
