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 is an oracle database?

1044

What is a connect identifier?

1042

State some uses of redo log files?

1012

How to calculate date and time differences in oracle?

1044

What is a parameter file in oracle?

1135

How to fetch the row which has the max value for a column?

1002

What is oracle thin client?

1028

What is Trigger in Oracle?

1176

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1053

Name the various constraints used in oracle?

1022

What is the difference between view and materialized view in Oracle?

1156

How to use existing values in update statements using oracle?

1069

What is difference between cartesian join and cross join?

1092

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2326

Difference between oracle's plus (+) notation and ansi join notation?

1108