select max(sal) from emp where sal<(select max(sal) from emp where sal&l

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

Question Posted / srinivas

Answer Posted / srinivas

select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which is better stored procedure or query?

549

Does user triggers have entry for trigger with compilation errors?

602

How do you copy a table in sql?

563

What are the advantages of sql? Explain

651

what are the advantages of using stored procedures? : Sql dba

622

what are enums used for in mysql? : Sql dba

612

Explain alias in sql?

585

What is a file delimiter?

558

What does plv msg allows you to do?

682

explain advantages of myisam over innodb? : Sql dba

608

Can triggers stop a dml statement from executing on a table?

619

Is sql a scripting language?

521

Is natural join and inner join same?

502

Enlist some predefined exceptions?

586

what is sub-query? : Transact sql

599