TIAA Interview Question

select 2nd highest salary

Interview Answers

Anonymous

Sep 7, 2022

select sal from (select sal from emp order by 1 desc limit 2) order by 1 limit 1

Anonymous

Feb 20, 2021

select max(sal) from emp where sal=select max(sal) from emp

1