Leetcode Mysqlテーマ
611 ワード
175. Combine Two Tables
https://leetcode.com/problems/combine-two-tables/description/
176. Second Highest Salary
https://leetcode.com/problems/second-highest-salary/description/
LIMIT a OFFSET bは、第b+1条の記録からa条の記録を取り出す
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)