title: How to get the max value for each group in Oracle?
body: <p>I've found some solutions for this problem, however, they don't seem to work with Oracle.</p>
  
  <p>I got this:</p>
  
  <p><a href="https://i.stack.imgur.com/YykTJ.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/YykTJ.jpg" alt="enter image description here"></a></p>
  
  <p>I want a view  to present only the informations about the oldest person for each team. So, my output should be something like this:</p>
  
  <pre><code>PERSON  | TEAM | AGE
  Sam     | 1    | 23
  Michael | 2    | 21
  </code></pre>
  
  <p>How can I do that in Oracle?</p>