Oracle Analytic Functions
Oracle analytic functions calculate an aggregate value based on a group of rows and return multiple rows for each group.
Oracle RANK() Function
In this tutorial, you will learn how to use Oracle RANK () function to calculate the rank of rows within a set of rows.
Oracle ROW_NUMBER Function
The ROW_NUMBER() is an analytic function that assigns a sequential unique integer to each row to which it is applied, either each row in the partition or each row in the result set.
Oracle NTILE Function
Summary: in this tutorial, you will learn how to use the Oracle NTILE() function to divide an ordered result set into a number of buckets and assign an appropriate bucket number to each …
Oracle LEAD() Function
In this tutorial, you will learn how to access the following row from the current row by using the Oracle LEAD () function.
Oracle FIRST_VALUE Function
In this tutorial, you will learn how to return the first value in an ordered set of values by using the Oracle FIRST_VALUE () function.
Oracle CUME_DIST Function
The CUME_DIST() function is an analytic function that calculates the cumulative distribution of a value in a set of values. Here’s the basic syntax of CUME_DIST() function:
Oracle LAG Function
In this tutorial, you will learn how to access the row at a given offset prior to the current row using Oracle LAG () function.
Oracle DENSE_RANK() Function
In this tutorial, you will learn how to use the Oracle DENSE_RANK () function to calculate the rank of a row in an ordered set of rows.
Oracle LAST_VALUE Function
In this tutorial, you will learn how to use the Oracle LAST_VALUE () function to return the last value in an ordered set of values.