select max(sal) from ( select sal from emp group by sal order by sal) where

how to check the 3rd max salary from an employee table?

Question Posted / tushar

Answer Posted / tushar

select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can procedure in package be overloaded?

1028

Is null operator in sql?

978

Explain locks? : Transact sql

951

What is the least restrictive isolation level? : Transact sql

995

How do I copy a table in sql?

928

Why do we use set serveroutput on?

922

Explain the working of foreign key?

976

how to use regular expression in pattern match conditions? : Sql dba

962

What is a pl/sql block?

1110

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1158

How do you write a subquery?

964

What does select * from mean in sql?

3068

how many sql dml commands are supported by 'mysql'? : Sql dba

1055

What are few of the schema objects that are created using PL/SQL?

968

What is the need of a partition key?

940