title: Aggregate operation oracle
body: <p>I have two tables and I need to find the person with the highest value.</p>
  
  <p>TABLE1</p>
  
  <blockquote>
  <pre><code>NAME           ID
  --------------- ---------------
    MIKE          101
    MIKE          102
    BETTY         103
    BETTY         104
    BETTY         105
    TIM           106
  </code></pre>
  </blockquote>
  
  <p>TABLE2</p>
  
  <blockquote>
  <pre><code>ID                VALUE
  --------       --------------
  101            12
  102            10
  103            20
  104            20
  105            10
  106             5
  </code></pre>
  </blockquote>
  
  <p>I can write a select statement that will give a result of name and values:</p>
  
  <blockquote>
  <pre><code>  SELECT name, value
      FROM table1, table2
      WHERE table1.id = table.id;
  </code></pre>
  </blockquote>
  
  <pre><code>  NAME    VALUE
   -----   ----------
    MIKE          12
    MIKE          10
    BETTY         20
    BETTY         20
    BETTY         10
    TIM           5
  </code></pre>
  
  <p>Now I need to aggregate the  values of the rows with equal names and I can not figure it out.  Am I going about it the correct way?</p>