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

Respected sir, Please send me technical questions related to oracle apps..

1868

What is logical backup in oracle?

1085

WHAT IS ecc 6.0

2205

How do I manually uninstall oracle client?

1152

Can sub procedure/function be called recursively?

1051

What is difference between cartesian join and cross join?

1159

what is dynamic SGA and static SGA

4491

List out the difference between commit, rollback, and savepoint?

1095

what are the default admin accounts in Oracle 10g ?

1024

what is normalisation?what are its uses?

2334

In oracle there is column command, how will you explain that?

1139

How to delete an existing row from a table in oracle?

1130

What is the dynamic sql in oracle?

1136

Explain the use of Merge statement in oracle 11g

1077

What are the different pseudo commands? Explain in general?

1125