LeetCode刷题——数据库篇

1

# Write your MySQL query statement below
select Person.FirstName,Person.LastName,Address.City,Address.State 
from Person left join Address on Person.PersonId=Address.PersonId

 

2

 

# Write your MySQL query statement below
select max(Salary) as SecondHighestSalary from Employee where Salary<(select max(Salary) from Employee)

 

 

3

 

 

4

5

6

7

8

9