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
(
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 folowing and I'm using
