title: SQL Update query with group by clause
body: <pre><code>Name         type       Age
  -------------------------------
  Vijay          1        23
  Kumar          2        26
  Anand          3        29
  Raju           2        23
  Babu           1        21
  Muthu          3        27
  --------------------------------------
  </code></pre>
  
  <p>Write a query to update the name of maximum age person in each type into 'HIGH'.</p>
  
  <p>And also please tell me, why the following query is not working</p>
  
  <pre><code>update table1 set name='HIGH' having age = max(age) group by type;
  </code></pre>