Infosys Interview Question: write SQL query to get the Sixth minimum salary | Glassdoor

Skip to content Skip to footer

Notifications

Loading...

employer cover photo

Infosys

Infosys Java Developer interview

Infosys Interview Question

Java Developer Interview

write SQL query to get the Sixth minimum salary

Interview Answers

Anonymous

Apr 12, 2019

select * from employees where rownum=6 order by salary

Anonymous

Jan 10, 2025

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

Related searches: Infosys reviews | Infosys jobs | Infosys salaries | Infosys benefits | Infosys conversations

Infosys interviews