title: min value from two columns (Oracle SQL)
body: <p>Searching for a while now, but haven't found a suitable answer to my problem. </p>
  
  <p>Explanation:</p>
  
  <pre>
  ID | Year |  Factor1 | Number1 | Number2
  1  | 2010 |   213    |    1     |   1     
  2  | 2010 |   213    |    1     |   2    
  3  | 2010 |   214    |    2     |   1    
  4  | 2010 |   214    |    2     |   2    
  6  | 2010 |   210    |    3     |   1    
  7  | 2010 |   210    |    3     |   2   
  8  | 2011 |   250    |    3     |   5 
  5  | 2012 |   214    |    2     |   4    
  </pre>
  
  <p>EDIT: 
  Forgot Something, corrected that in the above table.
  I need 2 combinations: year and factor1 only once, then min(number1) and last min(number2). 
  For example above I would need IDs 1,3,5,6,8 (sorry they are mixed for better readability of the other values).</p>
  
  <p>Anyone any idea how to realize that?</p>