Write query to fetch second maximum salary from employee table.
- 4 Answers
- 6572 Views
- Bravura Solutions, HCL, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar
select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens if you set the sga too low in oracle?
What are the extensions used by oracle reports?
How can I combine multiple rows into a comma-delimited list in oracle?
What are the different types of trigger and explain its various uses and functions?
What are a query and state the different types of queries and their uses?
Please explain oracle left join with an example?
Why we use bulk collect in oracle?
What is a dynamic performance view in oracle?
What is the string concatenation operator in oracle?
Why do you use stored procedures and state some of its disadvantages?
What is a cursor in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is a package ? What are the advantages of package ?
What are the advantages of oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
