- 博客(2)
- 收藏
- 关注
原创 About LeetCode
组合两个表 (Combine two tables)SELECT a.FirstName, a.LastName, b.City, b.StateFROMPerson as aLEFT JOINAddress as bON a.PersonId=b.PersonId第二高的薪水(The Second Highest Salary)select IFNULL ((select DISTINCT Salary from EmployeeORDER BY Salary DESClim..
2020-09-28 16:33:13 61
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人