title: How to get depatment wise max salary as well as name of employee having it?
body: <p>I have table like this. </p>
  
  <p><a href="https://i.stack.imgur.com/jqxMH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jqxMH.png" alt="enter image description here"></a>
  I want to find the max salary department wise and the name of employee who has it.
  I ran MySql query </p>
  
  <pre><code>select concat(First_name,' ',Last_name) as Name,max(SALARY) 
  from Employee 
  group by Department;
  </code></pre>
  
  <p>which gives result as shown below.</p>
  
  <p><a href="https://i.stack.imgur.com/CeFYU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CeFYU.png" alt="enter image description here"></a></p>
  
  <p>In which max(SALARY) is correct but Emplyoee name is wrong.How to get both correct? </p>