The Analytical Functions in Oracle (Analytical Functions I) : Introduction « Analytical Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Analytical Functions
3. Introduction

The analytical functions fall into categories:

1. ranking,
2. aggregate,
3. row comparison,
4. statistical.

The function has this syntax:

function() OVER()

For example, SELECT RANK() OVER(ORDER BY salary) FROM employee

The part may be empty, as it is in the above example: "RANK()."

The contains an ordering, partitioning, or windowing clause.

The ordering clause in the above example is "OVER(ORDER BY salary)."

An analytical function that uses an ordering may also partition the result set based on some attribute value.

The Row-numbering and Ranking Functions

1. ROW_NUMBER
2. RANK
3. DENSE_RANK
4. PERCENT_RANK
5. CUME_DIST
6. NTILE