PostgreSQL (window function) one-liner
\nselect distinct nth_value(salary, 2) over (order by salary desc rows between unbounded preceding and unbounded following) from employee;\n
```\nselect distinct nth_value(salary, 2) over (order by salary desc rows between unbounded preceding and unbounded following) from employee;\n```
[]