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

what are aggregate and scalar functions? : Sql dba

1122

define sql insert statement ? : Sql dba

1093

Is primary key always clustered index?

1090

What is your daily office routine?

2340

How do I remove duplicates in two columns?

1177

what are all the common sql function? : Sql dba

1125

Is primary key clustered index?

1012

What is the current version of sql?

1091

how to use regular expression in pattern match conditions? : Sql dba

1105

what are the advantages of sql ? : Sql dba

1136

what is dbms? : Sql dba

1058

Can we use distinct and group by together?

1129

Can delete statement be rollbacked?

1050

how to escape special characters in sql statements? : Sql dba

1110

what is schema? : Sql dba

1133