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

Explain foreign key in sql?

1084

What do you know by pl/sql cursors?

1170

What are the advantages of normalization?

1130

What are the main features of cursor?

1109

What is query execution plan in sql?

1249

What are expressions?

1062

How to Declare Fixed Length String Value In PL SQL

1208

What is the main reason behind using an index?

1060

Which type of cursor is used to execute the dml statement?

995

is mysql query is case sensitive? : Sql dba

1164

Describe sql comments?

1115

I need a function for a train ticket reservation please answer it thanks in advance

1078

What is sql table?

1022

what are the differences between require and include, include_once and require_once? : Sql dba

1071

Is record in oracle pl sql?

1017