select min(sal) from(select distinct(sal) from emp order by sal desc) where

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

Question Posted / akula

Answer Posted / akula

select min(sal) from(select distinct(sal) from emp order by sal desc) where rownum<=3;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is mdf ldf and ndf?

1002

What is t-sql? : Transact sql

988

What is primary key and foreign key with example?

932

What are the different tcl commands in sql?

1175

define data blocks ? : Sql dba

1000

What is pivot table in sql?

1108

What is mdb stand for?

1011

Can a table contain multiple primary key’s?

1098

What is the order of sql select?

1041

Is sql workbench free?

1003

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

Is sql open source?

979

What is sql exception?

975

What is compute?

1091

What is integrity in sql?

1046