利用窗口函数

SELECT AVG(salary)
FROM (
    SELECT *, 
    RANK() OVER(ORDER BY salary) r1,
    RANK() OVER(ORDER BY salary DESC) r2
    FROM salaries
    WHERE to_date = '9999-01-01'
) a
WHERE r1!=1 AND r2!=1