solve problem Department Highest Salary

P-ppc · P-ppc · commit 0d90db3f0ca0 · 2018-11-24T20:34:07.000+08:00
diff --git a/README.md b/README.md
@@ -335,4 +335,5 @@ All solutions will be accepted!
 |626|[Exchange Seats](https://leetcode-cn.com/problems/exchange-seats/description/)|[mysql](./database/ExchangeSeats)|Medium|
 |178|[Rank Scores](https://leetcode-cn.com/problems/rank-scores/description/)|[mysql](./database/RankScore)|Medium|
 |180|[Consecutive Numbers](https://leetcode-cn.com/problems/consecutive-numbers/description/)|[mysql](./database/ConsecutiveNumbers)|Medium|
-|177|[Nth Highest Salary](https://leetcode-cn.com/problems/nth-highest-salary/description/)|[mysql](./database/NthHighestSalary)|Medium|
+|177|[Nth Highest Salary](https://leetcode-cn.com/problems/nth-highest-salary/description/)|[mysql](./database/NthHighestSalary)|Medium|
+|184|[Department Highest Salary](https://leetcode-cn.com/problems/department-highest-salary/description/)|[mysql](./database/DepartmentHighestSalary)|Medium|
diff --git a/database/DepartmentHighestSalary/README.md b/database/DepartmentHighestSalary/README.md
@@ -0,0 +1,2 @@
+# Department Highest Salary
+We can solve this problem by MAX FUNCTION and sub-query
diff --git a/database/DepartmentHighestSalary/solution.sql b/database/DepartmentHighestSalary/solution.sql
@@ -0,0 +1,4 @@
+# Write your MySQL query statement below
+select d.Name as Department, e.Name as Employee, Salary
+from Employee as e, Department as d
+where e.DepartmentId = d.Id and Salary = (select max(Salary) from Employee where DepartmentId = d.Id)

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Department Highest Salary`
	`2`	`+We can solve this problem by MAX FUNCTION and sub-query`