select max(sal) from emp where sal!=(select max(sal) from emp where sal!=(

Find out the 3rd highest salary?

Question Posted / jagdish

Answer Posted / jagdish

select max(sal) from emp where sal!=(select max(sal) from
emp where sal!=(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is on delete restrict?

542

Can I learn sql in a week?

554

how mysql optimizes distinct? : Sql dba

555

What is procedure and function?

520

Is sql developer case sensitive?

520

What is difference between primary and secondary key?

519

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

646

How do I start sql profiler?

561

Which language is used in sql?

520

What is the limitation on the block size of pl/sql?

532

What is composite data type in pl sql?

559

What is the difference between an inner join and an outer join?

516

How to order siblings in oracle hierarchy queries?

600

How to run pl/sql statements in sql*plus?

594

How to take user input in pl sql?

705