select min(sal) from (select sal from (select distinct(sal) from emp orde

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

Question Posted / arjun

Answer Posted / arjun

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what are all the common sql function? : Sql dba

1125

Does group by remove duplicates?

1108

Can we rollback truncate?

1072

what is dbms? : Sql dba

1057

Can delete statement be rollbacked?

1050

Is primary key clustered index?

1011

How do I remove duplicates in two columns?

1177

what is sql server agent? : Sql dba

1173

what is schema? : Sql dba

1132

What is the best sql course?

1042

What is the current version of sql?

1091

Can we use distinct and group by together?

1129

how many tables will create when we create table, what are they? : Sql dba

1138

What is the current version of postgresql?

1163

what is bcp? When does it used? : Sql dba

1051