ALLInterview.com
Categories
|
Companies
|
Placement Papers
|
Code Snippets
|
Certifications
|
Visa Questions
Post Questions
|
Post Answers
|
My Panel
|
Search
|
Topics
|
Errors
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