December 2002
Intermediate to advanced
928 pages
85h 29m
English
LAG (expr[,offset][,default]) OVER (analytic_clause)
Provides access to more than one row of a table at the same time without a self-join. Analytic function only.
Physical offset prior to the current row for an additional row to be retrieved.
Value returned if the offset goes beyond the scope of the window.