Posts in: Analytical Functions
Analytical Functions
Learn how analytical functions in Oracle SQL allow complex calculations over a set of rows related to the current row without collapsing result sets.
Read More →RANK, DENSE_RANK, ROW_NUMBER
Use RANK, DENSE_RANK, and ROW_NUMBER to assign rankings or unique row numbers to result sets based on ordering criteria.
Read More →LAG, LEAD
Access previous or next row values using LAG and LEAD for comparing current rows with adjacent ones.
Read More →FIRST_VALUE, LAST_VALUE
Extract the first or last value in a partition using FIRST_VALUE and LAST_VALUE functions.
Read More →NTILE, PERCENT_RANK, CUME_DIST
Distribute rows into percentiles or calculate cumulative distribution and rank using NTILE, PERCENT_RANK, and CUME_DIST.
Read More →