摘要: select max(Salary) as SecondHighestSalaryfrom Employeewhere Salary < (select max(Salary) from Employee); 阅读全文
posted @ 2018-12-18 03:04 yuesi 阅读(82) 评论(0) 推荐(0)
摘要: select FirstName, LastName,City, State from Personleft join Address on Person.PersonId = Address.PersonId; 阅读全文
posted @ 2018-12-18 03:03 yuesi 阅读(107) 评论(0) 推荐(0)