modified: second-highest-salary.sql

JinkeCao · JinkeCao · commit 500083276ab9 · 2016-07-30T15:47:31.000+08:00
diff --git a/MySQL/second-highest-salary.sql b/MySQL/second-highest-salary.sql
@@ -13,5 +13,6 @@
 # For example, given the above Employee table, the second highest salary is 200. If there is no second highest salary, then the query should return null.
 #
 # Write your MySQL query statement below
-SELECT MAX(Salary) FROM Employee
-WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)
+select (SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)) SecondHighestSalary;
+# or
+SELECT (SELECT Salary FROM Employee GROUP BY Salary ORDER BY Salary DESC LIMIT 1,1) SecondHighestSalary;

Original file line number	Diff line number	Diff line change
`@@ -13,5 +13,6 @@`
`13`	`13`	`# For example, given the above Employee table, the second highest salary is 200. If there is no second highest salary, then the query should return null.`
`14`	`14`	`#`
`15`	`15`	`# Write your MySQL query statement below`
`16`		`-SELECT MAX(Salary) FROM Employee`
`17`		`-WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)`
	`16`	`+select (SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)) SecondHighestSalary;`
	`17`	`+# or`
	`18`	`+SELECT (SELECT Salary FROM Employee GROUP BY Salary ORDER BY Salary DESC LIMIT 1,1) SecondHighestSalary;`