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
Are the resulting relations of PRODUCT and JOIN operation the same?
What is 4NF?
State the different extensions for stored procedures?
What is Weak Entity set?
What is System R? What are its two major subsystems?
What is database architecture? : sql server architect
Brief theory of Network, Hierarchical schemas and their properties
What is difference between 2 tier and 3 tier architecture?
Which part of the RDBMS takes care of the data dictionary? How
What is Set-at-a-time or Set-oriented?
What is 3NF?
Explain about the return statement?
Explain the truncate command? : sql server architect
What is Data Independence?
What is extension and intension?