I'm sure Oracle's analytic functions can handle this, but I'm having a hard time wrapping my head around the syntax. If anyone has another solution, I'd be happy to hear it too.

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Now, I'm interested in generating percentiles from this data. For example, to determine the 75th percentile (by duration) you order the set, and grab the 9th record of the 12 total. This has a ...