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 is database architecture? : sql server architect
What is Data Independence?
Explain the microsoft sql server delete command? : sql server architect
What are the unary operations in Relational Algebra?
What are page splits? : sql server architect
Explain about the implementation of stored procedures?
What is database architecture?
What is degree of Relationship type?
Where the procedures are stored in database?
Do you know what the restrictions applicable while creating views are? : sql server architect
Explain about the implementation of business logic in stored procedures?
What do you mean by atomicity and aggregation?
What is the job of the information stored in data-dictionary?
What is an Extension of entity type?
What is VDL (View Definition Language)?