数据库习题

Paste_Image.png

答案：
SELECT Person.FirstName, Person.LastName, Address.City, Address.State from Person LEFT JOIN Address on Person.PersonId = Address.PersonId;

Paste_Image.png

答案：SELECT distinct Salary as SecondHighestSalary FROM ((select * from Employee) union (select null as Id, null as Salary from dual) ) c order by Salary desc limit 1,1;