|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2 days ago @ 5:49:04 PM
Posts: 2,
Visits: 3
|
|
Seems no build in available in tera data to calculate 90th or nth percentile for the given dataset
unlike ORACLE
Navnit
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
Teradata is slightly more generic - it uses QUANTILE which allows you to split into groups based on any fraction.
So 90th percentile is:
Select
blah,blah,blah
From somewhere
Qualify Quantile(100,col1) = 90
;
|
|
|
|