subject:"Re\: Percentile calculations"

RE: Percentile calculations

2003-02-09 Thread Karl Dyson

); Thanks for all help supplied, Karl -Original Message- From: Adam Nelson [mailto:[EMAIL PROTECTED]] Sent: 05 February 2003 18:32 To: 'Benjamin Pflugmann'; Karl Dyson Cc: [EMAIL PROTECTED] Subject: RE: Percentile calculations I believe you can do: select avg(scantime) from pe

RE: Percentile calculations

2003-02-06 Thread Adam Nelson

njamin Pflugmann [mailto:[EMAIL PROTECTED]] > Sent: Saturday, February 01, 2003 2:17 AM > To: Karl Dyson > Cc: [EMAIL PROTECTED] > Subject: Re: Percentile calculations > > > Hi. > > On Fri 2003-01-31 at 17:22:37 -, [EMAIL PROTECTED] wrote: > [...] > > select c

Re: Percentile calculations

2003-02-01 Thread Benjamin Pflugmann

Hi. On Fri 2003-01-31 at 17:22:37 -, [EMAIL PROTECTED] wrote: [...] > select count(*) from percentile where ; > > Work out 95% or this value. > > create temporary table percentile (id int unsigned auto_increment > primary key, scantime decimal(20,10)); > > insert into percentile (scantime)