LAG function Oracle

LAG function Oracle

by sqlandplsql

LAG function used to find previous row value within the same table. It is an example of analytical function.

Syntax :-

LAG(column, context, default) over partition clause

context – number of rows to go backward. Default is 1

default – default value returns. Default is null