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

Why is partition used in sql?

561

How many row comparison operators are used while working with a subquery?

554

How does a self join work?

532

Define commit, rollback and savepoint?

588

What are instead of triggers?

636

Is t sql a programming language?

551

What are the properties of a transaction?

590

What are the constraints available in sql?

596

What is join view in sql?

530

what is acid property in database? : Sql dba

571

How to use sql*plus built-in timers?

588

What is the difference between a subquery and a join?

541

What is pl sql variable?

524

What is java sql connection?

526

What is the difference between rename and alias?

723