Blog Post

SQL SERVER 2012 - How to get a value from previous result row effectively

,

Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row result in the current row for comparison purposes.  Fortunately, we do have a solution for this problem using self join. But I will share another efficient solution with you using LAG (an analytic function shipped with […]

Rate

Share

Share

Rate