title: MySql Sql MAX and SUM error
body: <pre><code>select sum(value) as 'Value',max(value)
  from table_name where sum(value)=max(sum(value)) group by id_name;
  </code></pre>
  
  <p>The error is: Invalid use of group function (ErrorNr. 1111)</p>
  
  <p>Any idea?</p>
  
  <p>Thanks.</p>