J.P. Morgan interview question

Java collection's question. getting the 3 rd highest record in sql

Interview Answer

Anonymous

1 Dec 2016

select * from (select salary from employ order by salary desc) where rownum = 3;