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?
What is 4NF?
Which is super key?
Explain about recursive stored procedures?
What is difference between two tier and three tier?
What is E-R model?
Does storing of data in stored procedures increase the access time? Explain?
What are the primitive operations common to all record management systems?
what is the difference between LENGTH AND SIZE?
What is the difference between a user defined function and a stored procedure?
Describe the three levels of data abstraction?
What are the three tiers in a 3 tier architecture?
What is end user data?
What is database architecture?
What are the different phases of transaction?