select max(sal) from emp where sal not in(select max(sal) from emp where

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

Question Posted / kumar sumit

Answer Posted / kumar sumit

select max(sal) from emp where sal not in(select max(sal)
from emp where sal not in(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How is data stored on a disk?

545

What are the different dml commands in sql?

586

Is nosql relational?

549

what are the different type of normalization? : Sql dba

556

What are user defined functions?

584

What is sql and its types?

625

What is data types in sql?

537

How do I save a stored procedure?

527

What does pl sql developer do?

511

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

518

How do I partition in sql?

542

How to change sql*plus system settings?

544

What are the types of keys?

516

How many clustered indexes can you have?

538

how is myisam table stored? : Sql dba

607