title: How to update rows based only on ROW_NUMBER()?
body: <p>Such SQL query:</p>
  
  <pre><code>SELECT ROW_NUMBER() OVER (PARTITION BY ID, YEAR order by ID ), ID, YEAR
  from table t
  </code></pre>
  
  <p>give me following query set:</p>
  
  <pre><code>1   1000415591  2012
  1   1000415591  2013
  2   1000415591  2013
  1   1000415591  2014
  2   1000415591  2014
  </code></pre>
  
  <p>How could I update records with ROW_NUMBER() equals to 2? Other fields of this records is identically (<code>select distinct from table where id = 1000415591</code> gives 3 records when there are 5 without <code>distinct</code> keyword), so I can depend only on ROW_NUMBER() value.</p>
  
  <p>I need solution for Oracle, because I saw something similar for SQL-Server but it won't work with Oracle.</p>