leetcode数据库题汇总(持续更新)
部分参考网上思路
1、组合两个表 #175
SELECT FirstName, LastName, City, State
FROM Person LEFT JOIN Address
ON Person.PersonId = Address.PersonId
2、第二高的薪水 #176
select max(Salary) as SecondHighestSalary from Employee where Salary<(select max(Salary) from Employee)