Domanda di colloquio di Infosys

write SQL query to get the Sixth minimum salary

Risposte di colloquio

Anonimo

12 apr 2019

select * from employees where rownum=6 order by salary

Anonimo

10 gen 2025

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