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 More
SQL Server Education (by the geeks, for the geeks)