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

How does left join work in sql?

516

What are the various levels of constraints?

659

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1706

Does sql use python?

559

What is difference between stored procedure and trigger?

531

Is left join and outer join same?

545

How do you drop a trigger?

540

What is a constraint?

565

What is sql comments?

648

How to disable a trigger name update_salary?

672

Explain table and field in sql?

581

Can we insert delete data in view?

542

How is a process of pl/sql compiled?

598

Why is sql important?

577

Is sql low level language?

574