Functions in TD

UDA

Functions in TD

Hi,

Can anyone explain with examples how to calculate 90th percentile and the Teradata
function used to calculate the same?

We have the funtion PERCENT_RANK() OVER (PARTITION BY () ORDER BY ())
in my Reporting tool which pulls data from TD.

Also please take (PERCENTILE_CONT (0.90) WITHIN GROUP (ORDER BY (trx.trx_date trx.ship_date_actual)),2) per_90 an oracle function as reference.

Thanks
Manju