On Fri, 29 Nov 2013 15:38:51 -0800 Hayden Livingston <halivings...@gmail.com> wrote:
> I want to find the 25th %ile latency for this rowset. > > (A) How do I create a Percentile Query? http://www.schemamania.org/sql/#rank.rows Rank the rows, multiply the rank by 100, and divide by their count. Choosing the 25th percentile is then just a WHERE clause. HTH. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
