title: Oracle SQL Analytics Function FirstValue with 'NULL' Values
body: <p>I have an issue with the analytics function FirstValue:(Syntax: </p>
  
  <pre><code>FIRST_VALUE(TAble1.Column2 IGNORE NULLS) OVER (PARTITION BY Column1 ORDER BY Column3 DESC)
  </code></pre>
  
  <p>Example:</p>
  
  <pre><code>Column1     Column2              Column3 
  1               A             01/01/2012
  1               (NULL)        02/01/2012
  1               (NULL)        03/01/2012
  </code></pre>
  
  <p>I want to retrieve one line using the analytics function describe above.</p>
  
  <pre><code>Column1     Column2              Column3 
  1               A             01/01/2012
  </code></pre>
  
  <p>The issue is that Oracle retrieve 2 lines, one with Null and one other with the value'A' in the column2</p>
  
  <p>Could you please help me to solve this issue?</p>
  
  <p>Best Regards</p>