Select from following answers:- Lead function cannot accept negative offset
- Lead function can accept negative offset
- Lead function cannot accept any offset
- Lead function can accept negative offset
- All Above
Lead 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