[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
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)
I've had a look through the archives and cannot see a solution to this.
I am wondering if there is a nicer way to do the following.
I have a table where one of the columns contains a time period for an
activity that I am logging. I need to grab the 95th percentile, when
ordered by duration. I