Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the fifth highest salary?
- 8 Answers
- 12936 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 tier in database?
Explain what are the restrictions that views have to follow? : sql server architect
Explain about the process which takes place to execute a stored routine?
What is a view? How it is related to data independence?
What is a two tier wage system?
Not only RDBMS takes care of locating data it also
What are the levels of architecture?
What is durability in DBMS?
What is an Extension of entity type?
What is system catalog or catalog relation? How is better known as?
How do you communicate with an RDBMS?
What is external database?
What is n tier architecture with example?
What is model database? : sql server architect
What is msdb database? : sql server architect
