Using your exact dataset listed at the bottom, I tried using "derived
tables" to combine your implementation under Alpha 4.1.1 as a single
statement. I expected a message saying it was to complex or out of some
resource but the server goes to 100 percent cpu and I have to kill it. I
even got it to
Mike Johnson wrote:
From: Robert Citek [mailto:[EMAIL PROTECTED]
Hello all,
How can I calculate the mean/median/mode from a set of data using SQL?
Mean seems to exist as the average (avg):
select name, avg(value) from table group by name
Is there a way to calculate median and mode with a gro
On Friday, December 5, Robert Citek wrote:
On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
How can I calculate the mean/median/mode from a set of data using SQL?
After a bit of googling, I found this link:
http://mysql.progen.com.tr/doc/en/Group_by_functions.html
and a few an
On Wednesday, December 3, 2003, at 06:27 PM, Robert Citek wrote:
How can I calculate the mean/median/mode from a set of data using SQL?
After a bit of googling, I found this link:
http://mysql.progen.com.tr/doc/en/Group_by_functions.html
and a few answers in the comments towards the bottom.
Belo
From: Robert Citek [mailto:[EMAIL PROTECTED]
> Hello all,
>
> How can I calculate the mean/median/mode from a set of data using SQL?
>
> Mean seems to exist as the average (avg):
>select name, avg(value) from table group by name
>
> Is there a way to calculate median and mode with a group b
