Analytical functions – Lead and Lag
LAG: Using this function we can fetch the nth row before (Lag) the Current row without using self-join. It is useful when we need to compare the current row values with …
Read MoreSQL Server Education (by the geeks, for the geeks)
LAG: Using this function we can fetch the nth row before (Lag) the Current row without using self-join. It is useful when we need to compare the current row values with …
Read More