title: how to retrieve the employee who got maximum bonus?
body: <p>I have to display the employee detail who has got the maximum bonus(one with employee details and another table with bonus details). Here I have created a 'performance bonus' column to sum up the multiple bonuses. How to retrieve the employee from that column?</p>
  <pre><code>select e.Employee_id,
         e.First_name,
         e.Department,
         e.Salary,
         coalesce((select sum(b.Bonus_Amount) 
      as Bonus-- Let's sum up all Employee's the bonuses
  from Employee_Bonus_Table b
  where b.Employee_ref_id = e.Employee_Id), 0) [Performance_bonus]
      from Employee_Table e
  </code></pre>