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