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

Is there any restriction on the use of union in embedded sql?

1205

What is sql basics?

1083

How to create your own reports in sql developer?

1066

How can you know that statistics should be updated?

1130

what is the difference between char and varchar data types? : Sql dba

1174

What is sql*plus?

1122

How do you update f as m and m as f from the below table testtable?

1935

What is trigger explain it?

1080

What are keys in sql?

1045

Is foreign key mandatory?

1064

What is pl/sql language case sensitive?

1183

what is 'mysqld'? : Sql dba

1020

what is the difference between cluster and non cluster index? : Sql dba

1081

What are different types of sql commands?

1207

What's the difference between a primary key and a clustered index?

1032