Bank of America Interview Question

get second highest salary from employee table

Interview Answers

Anonymous

Jun 22, 2016

Select sal from emp order by sal desc limit 1,1

1

Anonymous

Jan 10, 2016

select top 1 salary from (select top 2 salary from employee order by salary Desc )

1