leetcode
每日一题在哪LeetCode
上的
SQL
实践
该文件包含我在
MySQL
中对
LeetCode
SQL
问题的解决方案。
问题清单
简单的
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
中等的
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
难的
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
解决方案
SELECT
FirstName,
LastName,
City,
State
FROM
Person
LEFT
JOIN
Address
ON
Person
.
PersonId
=
Address
.
PersonId
SELECT
MAX
(Salary)
AS
SecondHighestSalary
FROM
Employee
WHERE
S
评论0
最新资源