LEAD LAG « Analytical Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Analytical Functions
  3. LEAD LAG
16.17.LEAD LAG
16.17.1.Using the LAG() and LEAD() Functions
16.17.2.The Row Comparison Functions - LEAD and LAG
16.17.3.The row comparison function partitioned as with other aggregates
16.17.4.LAG and LEAD Options
16.17.5.Lag salary over, lead salary over