soni


{ City } hyderabad
< Country > india
* Profession * test analyst
User No # 86841
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 3
Users Marked my Answers as Wrong # 5
Questions / { soni }
Questions Answers Category Views Company eMail




Answers / { soni }

Question { IBM, 10093 }

how to find the fifth highest salary?


Answer

select MIN(salary) from (select distinct salary from employees
order by salary desc) where ROWNUM < 6 ;

ITS SELECTING from employees table 5th highest salary

Is This Answer Correct ?    3 Yes 5 No