Leetcode Mysql题目
2017-09-23 本文已影响0人
C就要毕业了
175. Combine Two Tables
https://leetcode.com/problems/combine-two-tables/description/
SELECT FirstName, LastName, City, State
FROM Person AS p
LEFT JOIN Address as a
ON p.PersonId = a.PersonId
176. Second Highest Salary
https://leetcode.com/problems/second-highest-salary/description/
LIMIT a OFFSET b
取出第b+1条记录起的a条记录
SELECT Salary AS SecondHighestSalary
FROM Employee
ORDER BY Salary
LIMIT 1 OFFSET 1
SELECT max(Salary) AS SecondHighestSalary
FROM Employee
WHERE Salary < (SELECT max(Salary) FROM Employee)
