find out the second highest salary?
Answer Posted / madan kumar
select *from (select empno,deptno,min(sal) from emp
group by empno,deptno,sal
order by sal desc)
where rownum<=1
| 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?
How to pass a cursor variable to a procedure?
How to connect to a local oracle 10g xe server?
what is the difference between substr and instr function in oracle?
Name the various constraints used in oracle?
When do you get a .pll extension in oracle?
What are the different types of modules in oracle forms?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is object data modeling?
What is proxy method?
What are the set operators union, union all, minus & intersect meant to do?
What is oracle sid?
What is the data pump export utility?
How to import one table back from a dump file?
What is a subquery in oracle?