Interested to Buy Any Domain ? << Click Here >> for more details...
i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table
- 3 Answers
- 6038 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan
select max(sal) from emp where sal<(select max(sal) from
emp)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / surya
select * from emp where 2-1=(Select count(distinct(sal)
from emp e where emp.sal<e.sal and ename='mr.b.travel)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / obulesu
select * from (select e.*,dense_rank() over(order by sal desc) r from emp e) where r=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
How to convert dates to characters in oracle?
Can multiple cursors being opened at the same time?
What is a cluster?
What is meant by a deadlock situation?
What are the various oracle database objects?
what is the use of rank function?
17. Display the order number and average item cost for each order.
Where do we use decode and case statements?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Why we use bulk collect in oracle?
What is a proxy object?
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
Oracle General 
