write a query for the fifth highest salary?
Answer Posted / aravind
select * from (select sal from emp order by desc) emp where
rownum = 5
| Is This Answer Correct ? | 6 Yes | 14 No |
Post New Answer View All Answers
Explain various types of locks in a transaction? Which is better and why?
Explain partial key?
What are the various ways to execute a query in teradata?
What does specialization in DBMS mean?
What is sharded database?
What are database connection details?
can we delete autodiff back up that we have set through sql server agent.
What is global database name?
What is the advantage of varchar2 over char?
What is ole db source in ssis?
What is the role of tester in discovery(in Checklist)?
Write a query to get maximum and second maximum in oracle?
What is the importance of database partitioning?
can u combine pipeline parallelism and partition parallalism? how and whan?
What are indexes in oracle?