1 Reply Latest reply on Jan 22, 2015 1:12 PM by thatJeffSmith-Oracle

    Warning while typing the code

    Raj Nath

      I am getting a warning in sql developer when i am using ignore nulls with lead/lag function

      Below is one example

       

      SELECT

             lead(sal IGNORE NULLS)

               OVER (PARTITION BY deptno ORDER BY sal)

      FROM   emp;

       

      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.