Update second-highest-salary.sql

kamyu104 · web-flow · commit 6ddbcdbb8600 · 2016-07-30T23:12:51.000+08:00
diff --git a/MySQL/second-highest-salary.sql b/MySQL/second-highest-salary.sql
@@ -13,6 +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 (SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)) SecondHighestSalary;
+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,6 +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 (SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)) SecondHighestSalary;`
	`16`	`+SELECT (SELECT MAX(Salary) FROM Employee WHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee)) SecondHighestSalary;`
`17`	`17`	`# or`
`18`	`18`	`SELECT (SELECT Salary FROM Employee GROUP BY Salary ORDER BY Salary DESC LIMIT 1,1) SecondHighestSalary;`