Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the fifth highest salary?
- 8 Answers
- 12767 Views
- IBM, Infosys, I also Faced
- E-Mail Answers
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
What is a checkpoint and When does it occur?
What is system catalog or catalog relation? How is better known as?
Explain about the implementation of stored procedures?
When is a functional dependency F said to be minimal?
What is msdb database? : sql server architect
Explain about the implementation of business logic in stored procedures?
What is Functional Dependency?
What is an Extension of entity type?
What is single tier architecture?
What is BCNF (Boyce-Codd Normal Form)?
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
What is parallel database architecture?
What do data architects do?
What is Record-at-a-time?
Which part of the RDBMS takes care of the data dictionary? How
