select sal from (select sal,count(sal) over order by salary desc c)temp whe

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / apsar

Answer Posted / apsar

select sal from (select sal,count(sal) over order by salary desc c)temp where temp.c=&n;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which environment variables are absolutely critical in order to run the OUI?

2128

What is a package ? What are the advantages of package ?

1095

How do I manually uninstall oracle client?

1098

How to define a sub function?

1145

How to unlock the sample user account in oracle?

1025

What are the attributes of cursor?

1062

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

1000

What is blob datatype?

1135

Oracle

2385

What is a system tablespace and when it is created?

983

What are the differences between lov and list item?

1079

What is recovery manager(rman) backup in Oracle?

1195

What is key preserved table?

1029

How to invoke the data pump import utility?

1179

What is bulk copy or bcp in oracle?

1133