RE: Percentile calculations

2003-02-06 Thread Adam Nelson
[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 count(*) from percentile where criteria; Work out 95

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 criteria; 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)