Pregunta de entrevista de Infosys

write SQL query to get the Sixth minimum salary

Respuestas de entrevistas

Anónimo

12 abr 2019

select * from employees where rownum=6 order by salary

Anónimo

10 ene 2025

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