Pergunta de entrevista da empresa Infosys

write SQL query to get the Sixth minimum salary

Respostas da entrevista

Sigiloso

12 de abr. de 2019

select * from employees where rownum=6 order by salary

Sigiloso

10 de jan. de 2025

correct one is SELECT MIN(salary) FROM ( SELECT salary FROM employees ORDER BY salary ) WHERE ROWNUM = 6;