SQL & PL/SQL

Hi,

I am trying to retrieve the max, min and the 90th percentile from a table of results.

I want the 90th percentile for duration based on the timestamp_ in asc order.

My Table looks like this:

I have 2 queries to retrive this info, but is there a simpler solution by using one query. here are my queries:

Select MIN(DURATION), max(DURATION)

from t

;

select DURATION as nine from t

where TIMESTAMP_ =

(

select

Percentile_disc(0.90) within group (order by TIMESTAMP_) AS nth

from t

)

THANKS