solve problem Second Highest Salary

P-ppc · P-ppc · commit ffaab4995b8e · 2018-11-23T22:16:24.000+08:00
diff --git a/README.md b/README.md
@@ -330,4 +330,5 @@ All solutions will be accepted!
 |175|[Combine Two Tables](https://leetcode-cn.com/problems/combine-two-tables/description/)|[mysql](./database/CombineTwoTables)|Easy|
 |183|[Customers Who Never Order](https://leetcode-cn.com/problems/customers-who-never-order/description/)|[mysql](./database/CustomersWhoNeverOrder)|Easy|
 |197|[Rising Temperature](https://leetcode-cn.com/problems/rising-temperature/description/)|[mysql](./database/RisingTemperature)|Easy|
-|181|[Employees Earning More Than Their Managers](https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/description/)|[mysql](./database/EmployeesEarningMoreThanTheirManagers)|Easy|
+|181|[Employees Earning More Than Their Managers](https://leetcode-cn.com/problems/employees-earning-more-than-their-managers/description/)|[mysql](./database/EmployeesEarningMoreThanTheirManagers)|Easy|
+|176|[Second Highest Salary](https://leetcode-cn.com/problems/second-highest-salary/description/)|[mysql](./database/SecondHighestSalary)|Easy|
diff --git a/database/SecondHighestSalary/README.md b/database/SecondHighestSalary/README.md
@@ -0,0 +1,2 @@
+# Second Highest Salary
+We can solve this problem by limit and order by
diff --git a/database/SecondHighestSalary/solution.sql b/database/SecondHighestSalary/solution.sql
@@ -0,0 +1,4 @@
+# Write your MySQL query statement below
+select (
+    select distinct Salary from Employee order by Salary desc limit 1, 1
+) as SecondHighestSalary

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Second Highest Salary`
	`2`	`+We can solve this problem by limit and order by`