title: Select Max Data from Subquery SQL, but it Show All Results from Subquery
body: <pre><code>SELECT MAX( t.valuesum ) AS total, t.codebook
  FROM (
      SELECT SUM( value ) AS valuesum, codebook
      FROM stock
      GROUP BY codebook
  ) t
  GROUP BY t.codebook
  </code></pre>
  
  <p>In the subquery, the output is :</p>
  
  <pre><code>b001 35,
  b002 20,
  b0003 11
  </code></pre>
  
  <p>I want to only see: b001 35. Please help me.</p>