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

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / m

Answer Posted / m

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

Is This Answer Correct ?

219 Yes

39 No

Please Help Members By Posting Answers For Below Questions

Explain the steps needed to create the scheduled job?

548

What is a constraint? Tell me about its various levels.

632

What is varchar example?

562

which operator is used in query for pattern matching? : Sql dba

538

What does varchar include?

513

When is the update_statistics command used?

566

Which is the correct statement about truncate and delete?

517

Is join same as left join?

520

Why do we use subquery?

479

Explain what is sql*plus?

662

How does a trigger work?

529

how to use 'mysql' to run sql statements? : Sql dba

530

What are the ddl commands?

527

How do I install microsoft sql?

517

What do you mean by field in sql?

525