Question d’entretien chez Infosys

write SQL query to get the Sixth minimum salary

Réponses aux questions d'entretien

Utilisateur anonyme

12 avr. 2019

select * from employees where rownum=6 order by salary

Utilisateur anonyme

10 janv. 2025

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