how to find the fifth highest salary?
Answer Posted / soni
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 |
Post New Answer View All Answers
Describe the three levels of data abstraction?
What is the difference between layer and tier?
What are pages and extents? : sql server architect
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
What is internal database?
What is DML (Data Manipulation Language)?
Do you know what the restrictions applicable while creating views are? : sql server architect
What is Set-at-a-time or Set-oriented?
What is a query?
How do you communicate with an RDBMS?
When is a functional dependency F said to be minimal?
Explain the truncate command? : sql server architect
What is Fully Functional dependency?
What is one tier architecture?
What is Multivalued dependency?