Select from following answers:- Specifying null value in offset yields null
- Fractional values are accepted in the offset clause of Lead function
- Lead function cannot accept negative offset
- All of the above

- All Above
All of the above are true because
a)Lead function cannot accept negative offset
b)Giving null value in offset yields null e.g.
Select Lead (getdate(),null) Over(Order by (Select 1))
c)We can even use fractions in the offset clause of Lead function e.g.
Select Lead (getdate(),12/10) Over(Order by (Select 1))
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator