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

How can I change database name in sql?

1089

Why do we use sqlite?

990

What is hibernate and its relation to sql?

1128

What are the types of join in sql?

1107

Define commit, rollback and savepoint?

1036

What is coalesce sql?

1006

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1134

What do you mean by stored procedures? How do we use it?

998

Can you have more than one key in a database?

941

What are triggers and its types?

1075

How do I partition in sql?

968

How does cross join work in sql?

1023

Differentiate between pl/sql and sql?

1156

What is the difference between function and procedure in pl/sql?

1095

What is data modelling in sql?

1026