RE: Solved - median (was Re: mean/median/mode)

2003-12-12 Thread emierzwa
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

Re: Solved - median (was Re: mean/median/mode)

2003-12-11 Thread Michael Stassen
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