Oracle Analytic Funcation: LAG() To Analyze Yearly Sales
The Oracle LAG() OVER(PARTITION BY ... ORDER BY ...) function is used to create
current year to previous year data setup, which can used to analyze year over
year growth in any data entity such as sales, quantity, customer count etc.