title: Maximum average departmental salary
body: <p>i have employee and department table i need to find maximum average departmental salary.We can have two more than 1 maximum value.I tried the following query</p>
  
  <pre><code>select dept.name,avg(employee.sal)
  from employee,dept
  where dept.id=empolyee.id
  group by dept.name
  LIMIT 1
  </code></pre>
  
  <p>however i can manage only one maximum average salary, how can i get query more than one maximum value</p>