The LAST Function in Oracle SQL / PLSQL is used to get the last value in an ordered set of records.
The LAST function can be used with the following functions.
- STDDEV() and
Syntax for using the LAST function in Oracle SQL / PLSQL is ;
AGGREGATE_FUNCTION() KEEP (RANK_FUNCTION LAST ORDER BY AGGREGATE_FUNCTION(COLUMN))
GROUP BY column(s);
Suppose we have a table named ‘employee’ as shown below:
Now, suppose we want to get the name of the department where the total salary being given is higher than total of salary in any other department, then we can achieve the same using LAST function as:
SELECT MAX(department) KEEP (DENSE_RANK LAST ORDER BY SUM(salary)) Max_Sal_Department FROM employee GROUP BY department;
We will get the following result:
Here we can see that we have successfully fetched the name of the department in which the total salary is greater than total salary of any other department.