Obtaining Analytical Data

Analytical functions manipulate data within result sets. Rank analytical functions rank items in a group. Inverse distribution analytical functions return a k-th percentile value.

• Rank Analytical Functions
  Rank analytical functions rank items in a group, compute distribution, and divide a result set into a number of groupings .Rank analytical functions include: RANK, DENSE_RANK, PERCENT_RANK, and NTILE. The inverse distribution analytical functions are PERCENTILE_CONT and PERCENTILE_DISC.
• Inverse Distribution Functions
  The inverse distribution analytical functions return a k-th percentile value, which can be used to help establish a threshold acceptance value for a set of data.