Re: Calculation of a '95th percentile'

[angel rivero]

Rick James Wrote:
-------------------------------------------------------
> 1. CREATE TEMPORARY TABLE ... <- this is where seq
> got defined
> 2. SELECT from that table.
>
> (The details were in
> http://forums.mysql.com/read.php?10,378701,378740
> )

mysql> CREATE TEMPORARY TABLE cm714.PCT_O2_PPM (seq INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY) SELECT O2_PPM FROM cm714.listfiles ORDER BY O2_PPM;
Query OK, 50 rows affected (0.03 sec)
Records: 50  Duplicates: 0  Warnings: 0

mysql> SELECT O2_PPM FROM cm714.PCT_O2_PPM WHERE seq >= 0.90 * @ct ORDER BY seq LIMIT 2;
Empty set (0.00 sec)

Why?



Edited 1 time(s). Last edit at 08/02/2010 02:22AM by angel rivero.