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
What is Multivalued dependency?
What is SDL (Storage Definition Language)?
What is Weak Entity set?
What is System R? What are its two major subsystems?
Name the sub-systems of a RDBMS?
What are page splits? : sql server architect
What is a checkpoint and When does it occur?
What is extension and intension?
What is 3NF?
Does storing of data in stored procedures increase the access time? Explain?
What are pages and extents? : sql server architect
What is system catalog or catalog relation? How is better known as?
When is a functional dependency F said to be minimal?
in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?
What is an Entity?