Department Highest Salary

https://leetcode.com/problems/department-highest-salary/

SELECT dep.Name as Department, emp.Name as Employee, emp.Salary 
from Department dep, Employee emp 
where emp.DepartmentId=dep.Id 
and emp.Salary=(Select max(Salary) from Employee e2 where e2.DepartmentId=dep.Id)

SELECT dep.Name as Department, emp.Name as Employee, emp.Salary  
FROM Department dep, Employee emp  
WHERE emp.DepartmentId = dep.Id AND emp.Salary =  
      (SELECT max(Salary) 
       FROM Employee emp2 
       WHERE emp2.DepartmentId = dep.Id)

REF:

• https://discuss.leetcode.com/topic/22623/simple-solution-easy-to-understand
• http://koonote.com/leetcode-184/