Select from following answers:- Lag function cannot accept negative offset
- Lag function can accept negative offset
- Lag function can accept negative offset
- Lag function cannot accept any offset
- All Above
Lag function cannot accept negative offset.If we specify so, the Query Engine will report below error
Msg 8730, Level 16, State 1
Offset parameter for Lag and Lead functions cannot be a negative value.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator