About LeetCode
组合两个表 (Combine two tables)
SELECT a.FirstName, a.LastName, b.City, b.State
FROM
Person as a
LEFT JOIN
Address as b
ON a.PersonId=b.PersonId
第二高的薪水(The Second Highest Salary)
select IFNULL (
(select DISTINCT Salary from Employee
ORDER BY Salary DESC
lim..
原创
2020-09-28 16:33:13 ·
45 阅读 ·
0 评论