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.

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 ...