Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the fifth highest salary?
- 8 Answers
- 12442 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 DML Compiler?
Not only RDBMS takes care of locating data it also
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
What is a Database system?
What do you know about system database? : sql server architect
What is one tier architecture?
What is DML (Data Manipulation Language)?
What is end user data?
What is degree of Relationship type?
What are the levels of architecture?
What is Relationship type?
What do you mean by flat file database?
What is external database?
What is Data Model?
What is the job of the information stored in data-dictionary?
