题解 | #SQL54 平均工资#
平均工资
http://www.nowcoder.com/practice/95078e5e1fba4438b85d9f11240bc591
也行，但好像更长了之外，效率上也没啥区别
select avg(ss.salary)
from salaries ss
left join (select max(salary) salary from salaries where to_date='9999-01-01'
union
select min(salary) salary from salaries where to_date='9999-01-01') t
on ss.salary=t.salary
where t.salary is null and ss.to_date='9999-01-01'
查看15道真题和解析