select min(empsal) from (select * from sal order by empsal desc) where

how to find the second highest salary from emp table?

Question Posted / abir dutta

Answer Posted / abir dutta

select min(empsal)
from (select * from sal order by empsal desc)
where rownum <=2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

difference between anonymous blocks and sub-programs.

1081

Explain what is a subquery ?

1125

how many ways to get the current time? : Sql dba

950

What is data control language (dcl)?

1047

what is row? : Sql dba

1169

What is the limitation on the block size of pl/sql?

938

How to use sql statements in pl/sql?

1055

Can variables be used in sql statements?

982

What are different types of sql commands?

1026

Is sql procedural language?

921

What are the advantages of pl sql over sql?

964

Differentiate pl/sql and sql?

1013

What is output spooling in sql*plus?

986

What is difference between primary and secondary key?

976

When to use inner join and left join?

907