select *from (select empno,deptno,min(sal) from emp group by empno,deptno,

find out the second highest salary?

Question Posted / madan kumar

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

Please Help Members By Posting Answers For Below Questions

What happens if you set the sga too low in oracle?

1057

How to pass a cursor variable to a procedure?

1042

How to connect to a local oracle 10g xe server?

941

what is the difference between substr and instr function in oracle?

1036

Name the various constraints used in oracle?

974

When do you get a .pll extension in oracle?

1081

What are the different types of modules in oracle forms?

953

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2131

What is object data modeling?

907

What is proxy method?

931

What are the set operators union, union all, minus & intersect meant to do?

941

What is oracle sid?

893

What is the data pump export utility?

1023

How to import one table back from a dump file?

972

What is a subquery in oracle?

1044