How to get the max value for each group in Oracle?
<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>