题解 | #平均工资#
平均工资
http://www.nowcoder.com/practice/95078e5e1fba4438b85d9f11240bc591
-- in后面只能有一个字段。 -- <>后面只能有一个字段.不能同时与一个查询出两个字段的临时表比较，salary是一个字段，不能和两个字段比较 -- 注意排除在职(to_date = '9999-01-01' )员工
select avg(salary) as avg_salary from salaries where to_date = '9999-01-01' and salary not in (select min(salary) from salaries where to_date = '9999-01-01') and salary not in(select max(salary) from salaries where to_date = '9999-01-01' );
查看15道真题和解析
海康威视公司福利 1086人发布