I am getting a warning in sql developer when i am using ignore nulls with lead/lag function
Below is one example
lead(sal IGNORE NULLS)
OVER (PARTITION BY deptno ORDER BY sal)
but when i use the same with other analytical function like first_value, it does not show any warning. but in both cases it does give correct output. But still i would like to know as why sql developer is not recognising ignore nulls with lead function.
It's a known issue with our grammar checker and analytics.