【文件属性】:
文件名称:leetcode每日一题在哪-SQL-Practices-Leetcode:SQL-实践-Leetcode
文件大小:18KB
文件格式:ZIP
更新时间:2021-06-30 07:03:48
系统开源
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
【文件预览】:
SQL-Practices-Leetcode-master
----LICENSE(1KB)
----ReadMe.md(77KB)