leetcode刷题 --数据库

组合两个表：

题目链接

• 解题思路：左连接

select FirstName, LastName, City, State 
from person natural left join address;
-- 或
select FirstName, LastName, City, State 
from person p left join address a on p.PersonID = a.PersonID

第二高的薪水：

题目链接

• 解题思路：用distinct去除重复值，倒序排序之后再用limit选出第二高的

select distinct Salary as SecondHighestSalary 
from Employee 
order by Salary desc 
limit 1,1;

无语，做错了，题目要求如果不存在第二高的薪水，那么查询应返回 null，这里用IFNULL()函数来实现

select IFNULL((select distinct Salary
from Employee
order by Salary desc
limit <