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
- 6146 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 many columns can a plsql table have
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
difference between oracle8i and oracle9i
What is the difference between Outer join and Full outer join?
What are the factors causing the reparsing of SQL statements in SGA?
what is null value?
What to do if the binary spfile is wrong for the default instance?
How to end the current transaction in oracle?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
How to call a stored function in oracle?
How to use "in" parameter properly?
What are the restrictions on external table columns?
Oracle General 
