SQL Coding Challenge – Leetcode

By |2018-07-26T21:39:33-04:00July 26th, 2018|Categories: Note笔记|Tags: , , |

Easy Difficulty Combine Two Tables - LeetCode SELECT FirstName, LastName, City, State FROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId; Second Highest Salary - LeetCode SELECT distinct(Salary) AS SecondHighestSalary FROM Employee UNION SELECT NULL ORDER BY SecondHighestSalary DESC LIMIT 1, 1; Employee Earning More Than Their Managers Assign two different names for single table and [...]