how to find the fifth highest salary?
Answer Posted / nagireddy karri
select min(emp_sal) from (select (Emp_sal) from(select
Emp_sal from emp order by emp_sal desc) and rownum<=5)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by flat file database?
Explain about the process which takes place to execute a stored routine?
What are the three tiers in a 3 tier architecture?
What is difference between 2 tier and 3 tier architecture?
What is Multivalued dependency?
What is "transparent DBMS"?
What is SDL (Storage Definition Language)?
What is an Entity set?
Explain the microsoft sql server delete command? : sql server architect
What is n tier architecture with example?
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?
What is Relationship set?
What is indexing and what are the different kinds of indexing?
Does storing of data in stored procedures increase the access time? Explain?