On 11/29/2013 6:38 PM, Hayden Livingston wrote:
I have a table {operationId, latency) with a set of rows that have floating values for latencies of a given operation.I want to find the 25th %ile latency for this rowset.
If you mean "a value X such that 25% of all operations had latency greater than X", then something like this:
select min(latency) from ( select latency from MyTable order by latency desc limit .25 * (select count(*) from MyTable) ); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
