- 科技
- 牛客SQL练习-54-查找排除最大、最小salary之后的当前(to
SELECT
AVG( salary
) AS avg_salary
FROM
salaries
WHERE
to_date
= '9999-01-01'
AND salary
NOT IN ( SELECT MAX( salary
) FROM salaries
WHERE to_date
= '9999-01-01' )
AND salary
NOT IN (
SELECT
MIN( salary
)
FROM
salaries
WHERE
to_date
= '9999-01-01')
Processed:
0.017, SQL:
9
