摘要:
找第二大# Write your MySQL query statement belowSELECT MAX(Salary) FROM EmployeeWHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee) 阅读全文
posted @ 2015-01-11 20:06 1957 阅读(255) 评论(0) 推荐(0)
|
|||
|
摘要:
找第二大# Write your MySQL query statement belowSELECT MAX(Salary) FROM EmployeeWHERE Salary NOT IN (SELECT MAX(Salary) FROM Employee) 阅读全文
posted @ 2015-01-11 20:06 1957 阅读(255) 评论(0) 推荐(0)
摘要:
leetcode竟然有sql的题了。。两道简单的应该会做这个题主要就是一个left join...# Write your MySQL query statement belowSELECT Person.FirstName, Person.LastName, Address.City, Addre... 阅读全文
posted @ 2015-01-11 20:05 1957 阅读(965) 评论(0) 推荐(0) |
|||