Select from following answers:- It is an analytic function and this function returns result set starting from the previous row in the table.
- It is an ranking function and this function returns result set starting from the previous row in the table.
- It is an ranking function and this function returns result set starting from the next row in the table.
- It is an analytic function and this function returns result set starting from the next row in the table.
- All Above
LAG is an analytic function.This function returns result set starting from the previous row in the table. This function is available since SQL SERVER 2012 (DENALI).
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator