solve problem Nth Highest Salary

P-ppc · P-ppc · commit 20580845d78b · 2018-11-24T20:12:37.000+08:00
diff --git a/README.md b/README.md
@@ -334,4 +334,5 @@ All solutions will be accepted!
 |176|[Second Highest Salary](https://leetcode-cn.com/problems/second-highest-salary/description/)|[mysql](./database/SecondHighestSalary)|Easy|
 |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|
+|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|
diff --git a/database/NthHighestSalary/README.md b/database/NthHighestSalary/README.md
@@ -0,0 +1,2 @@
+# Nth Highest Salary
+We can solve this problem by MYSQL FUNCTION
diff --git a/database/NthHighestSalary/solution.sql b/database/NthHighestSalary/solution.sql
@@ -0,0 +1,9 @@
+CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT
+BEGIN
+  DECLARE M INT;
+  SET M = N - 1;
+  RETURN (
+      # Write your MySQL query statement below.
+    select distinct Salary from Employee order by Salary desc limit M, 1
+  );
+END

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Nth Highest Salary`
	`2`	`+We can solve this problem by MYSQL FUNCTION`