title: Multiple max values in a query
body: <p>I know the title does not sound very descriptive, but it is the best I could think of:</p>
  
  <p>I have this table</p>
  
  <pre>
  ID     BDATE      VALUE
  28911  14/4/2009  44820
  28911  17/4/2009  32240
  28911  20/4/2009  30550
  28911  22/4/2009  4422587,5
  28911  23/4/2009  4441659
  28911  24/4/2009  7749594,67
  38537  17/4/2009  58280
  38537  20/4/2009  137240
  38537  22/4/2009  81098692
  38605  14/4/2009  2722368
  38605  20/4/2009  5600
  38605  22/4/2009  1625400
  38605  23/4/2009  6936575
  
  </pre>
  
  <p>which is in fact a very complicated query encapsulated in a view, but it is not of the matter now.</p>
  
  <p>I would like to have for each ID, the row containing the highest BDate. In this example, this would be the result. </p>
  
  <pre>
  ID     BDATE      VALUE
  28911  24/4/2009  7749594,67
  38537  22/4/2009  81098692
  38605  23/4/2009  6936575
  </pre>
  
  <p>I have already tried</p>
  
  <pre><code>select id, max(bdate), value from myview group by id, value
  </code></pre>
  
  <p>but then it returns all the rows, because for each the value collumn is different. This query is designed in Oracle v10, and I am eligible to use only select queries and not to create procedures.</p>